APPS.IGI_SAP_INVOICE_CLERK_PKG dependencies on IGI_SAP_INVOICE_CLERK

Line 1: PACKAGE BODY IGI_SAP_INVOICE_CLERK_PKG as

1: PACKAGE BODY IGI_SAP_INVOICE_CLERK_PKG as
2: -- $Header: igisiadb.pls 120.4.12000000.1 2007/09/12 11:47:32 mbremkum ship $
3:
4: l_debug_level number:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 25: CURSOR C IS SELECT rowid FROM IGI_SAP_INVOICE_CLERK

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_INVOICE_CLERK
26: WHERE group_id = X_Group_Id
27: AND clerk_id = X_Clerk_Id;
28: BEGIN
29: INSERT INTO IGI_SAP_INVOICE_CLERK(

Line 29: INSERT INTO IGI_SAP_INVOICE_CLERK(

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

Line 65: FROM IGI_SAP_INVOICE_CLERK

61: X_Start_Date_Active DATE,
62: X_End_Date_Active DATE) IS
63: CURSOR C IS
64: SELECT *
65: FROM IGI_SAP_INVOICE_CLERK
66: WHERE rowid = X_Rowid
67: FOR UPDATE of Group_Id NOWAIT;
68: Recinfo C%ROWTYPE;
69: BEGIN

Line 77: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg1',FALSE);

73: CLOSE C;
74: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
75: --Bug 3199481 (start)
76: If (l_unexp_level >= l_debug_level) then
77: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg1',FALSE);
78: End if;
79: --Bug 3199481 (end)
80: APP_EXCEPTION.Raise_Exception;
81: end if;

Line 96: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg2',FALSE);

92: else
93: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
94: --Bug 3199481 (start)
95: If (l_unexp_level >= l_debug_level) then
96: FND_LOG.MESSAGE(l_unexp_level,'igi.plsql.igi_sap_invoice_clerk_pkg.lock_row.Msg2',FALSE);
97: End if;
98: --Bug 3199481 (end)
99: APP_EXCEPTION.Raise_Exception;
100: end if;

Line 112: UPDATE IGI_SAP_INVOICE_CLERK

108: X_Last_Update_Date DATE,
109: X_Last_Updated_By NUMBER
110: ) IS
111: BEGIN
112: UPDATE IGI_SAP_INVOICE_CLERK
113: SET
114: group_id = X_Group_Id,
115: clerk_id = X_Clerk_Id,
116: start_date_active = X_Start_Date_Active,

Line 129: DELETE FROM IGI_SAP_INVOICE_CLERK

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

Line 137: END IGI_SAP_INVOICE_CLERK_PKG;

133: Raise NO_DATA_FOUND;
134: end if;
135: END Delete_Row;
136:
137: END IGI_SAP_INVOICE_CLERK_PKG;