Tuesday, September 12, 2017

API to Update FND Form (FND_FORM_PKG.UPDATE_ROW)

DECLARE
   l_form_id   NUMBER := 1001;
BEGIN
   FND_FORM_PKG.UPDATE_ROW (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_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; /