APPS.AMS_APPROVERS_PKG dependencies on AMS_APPROVERS_S

Line 154: update AMS_APPROVERS set

150: X_LAST_UPDATED_BY in NUMBER,
151: X_LAST_UPDATE_LOGIN in NUMBER
152: ) is
153: begin
154: update AMS_APPROVERS set
155: SEEDED_FLAG = X_SEEDED_FLAG,
156: ACTIVE_FLAG = nvl(X_ACTIVE_FLAG, 'Y'),
157: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
158: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 224: select AMS_APPROVERS_S.nextval

220: from AMS_APPROVERS
221: where approver_id = X_APPROVER_ID;
222:
223: cursor c_get_apr_id is
224: select AMS_APPROVERS_S.nextval
225: from dual;
226:
227: BEGIN
228: if X_OWNER = 'SEED' then