DBA Data[Home] [Help]

APPS.AHL_APPROVERS_PKG dependencies on AHL_APPROVERS_S

Line 145: update AHL_APPROVERS set

141: X_ATTRIBUTE14 IN VARCHAR2,
142: X_ATTRIBUTE15 IN VARCHAR2
143: ) is
144: begin
145: update AHL_APPROVERS set
146: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
147: APPROVAL_RULE_ID = X_APPROVAL_RULE_ID,
148: APPROVER_TYPE_CODE = X_APPROVER_TYPE_CODE,
149: APPROVER_SEQUENCE = X_APPROVER_SEQUENCE,

Line 241: SELECT ahl_approvers_s.NEXTVAL

237: FROM AHL_APPROVERS
238: WHERE approval_approver_id = X_APPROVAL_APPROVER_ID;
239:
240: CURSOR c_get_approver_id IS
241: SELECT ahl_approvers_s.NEXTVAL
242: FROM dual;
243:
244:
245: BEGIN