Tuesday, September 12, 2017

API to Create FND Form (FND_FORM_PKG.INSERT_ROW)

DECLARE
   l_row_id    VARCHAR2 (100);
   l_form_id   NUMBER;
BEGIN
   FND_FORM_PKG.INSERT_ROW (X_ROWID                => l_row_id,
                            X_APPLICATION_ID       => 7000,
                            X_FORM_ID              => l_form_id,
                            X_FORM_NAME            => 'TEST',
                            X_AUDIT_ENABLED_FLAG   => 'N',
                            X_USER_FORM_NAME       => 'Test',
                            X_DESCRIPTION          => 'Test',
                            X_CREATION_DATE        => SYSDATE,
                            X_CREATED_BY           => -1,
                            X_LAST_UPDATE_DATE     => SYSDATE,
                            X_LAST_UPDATED_BY      => -1,
                            X_LAST_UPDATE_LOGIN    => 0);
   COMMIT;
END;
/

No comments:

Post a Comment

API to Delete FND Application (FND_APPLICATION_PKG.DELETE_ROW)

BEGIN    FND_APPLICATION_PKG.DELETE_ROW (X_APPLICATION_ID => 20003); END; /