APPS.IGI_SAP_DEPT_APPROVERS_PKG dependencies on IGI_SAP_DEPARTMENT_APPROVERS

Line 25: CURSOR C IS SELECT rowid FROM IGI_SAP_DEPARTMENT_APPROVERS

21: X_Last_Update_Login NUMBER,
22: X_Last_Update_Date DATE,
23: X_Last_Updated_By NUMBER
24: ) IS
25: CURSOR C IS SELECT rowid FROM IGI_SAP_DEPARTMENT_APPROVERS
26: WHERE group_id = X_Group_Id
27: AND approver_id = X_Approver_Id;
28: BEGIN
29: INSERT INTO IGI_SAP_DEPARTMENT_APPROVERS(

Line 29: INSERT INTO IGI_SAP_DEPARTMENT_APPROVERS(

25: CURSOR C IS SELECT rowid FROM IGI_SAP_DEPARTMENT_APPROVERS
26: WHERE group_id = X_Group_Id
27: AND approver_id = X_Approver_Id;
28: BEGIN
29: INSERT INTO IGI_SAP_DEPARTMENT_APPROVERS(
30: group_id,
31: approver_id,
32: start_date_active,
33: end_date_active,

Line 68: FROM IGI_SAP_DEPARTMENT_APPROVERS

64: X_End_Date_Active DATE
65: ) IS
66: CURSOR C IS
67: SELECT *
68: FROM IGI_SAP_DEPARTMENT_APPROVERS
69: WHERE rowid = X_Rowid
70: FOR UPDATE of Group_Id NOWAIT;
71: Recinfo C%ROWTYPE;
72: BEGIN

Line 114: UPDATE IGI_SAP_DEPARTMENT_APPROVERS

110: X_Last_Update_Login NUMBER,
111: X_Last_Update_Date DATE,
112: X_Last_Updated_By NUMBER) IS
113: BEGIN
114: UPDATE IGI_SAP_DEPARTMENT_APPROVERS
115: SET
116: group_id = X_Group_Id,
117: approver_id = X_Approver_Id,
118: start_date_active = X_Start_Date_Active,

Line 130: DELETE FROM IGI_SAP_DEPARTMENT_APPROVERS

126: end if;
127: END Update_Row;
128: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
129: BEGIN
130: DELETE FROM IGI_SAP_DEPARTMENT_APPROVERS
131: WHERE rowid = X_Rowid;
132:
133: if (SQL%NOTFOUND) then
134: Raise NO_DATA_FOUND;