DBA Data[Home] [Help]

APPS.AMS_APPROVAL_DETAILS_PKG dependencies on AMS_APPROVAL_DETAILS_S

Line 271: update AMS_APPROVAL_DETAILS set

267: X_LAST_UPDATED_BY in NUMBER,
268: X_LAST_UPDATE_LOGIN in NUMBER
269: ) is
270: begin
271: update AMS_APPROVAL_DETAILS set
272: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
273: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
274: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
275: --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,

Line 461: select AMS_APPROVAL_DETAILS_S.nextval

457: from AMS_APPROVAL_DETAILS
458: where approval_detail_id = X_APPROVAL_DETAIL_ID;
459:
460: cursor c_get_apr_dtl_id is
461: select AMS_APPROVAL_DETAILS_S.nextval
462: from dual;
463:
464: BEGIN
465: if X_OWNER = 'SEED' then