APPS.GL_INTERCOMPANY_ACCTS_PKG dependencies on GL_INTERCOMPANY_ACC_SETS

Line 15: FROM gl_intercompany_acc_sets ia

11: x_je_source_name VARCHAR2,
12: x_je_category_name VARCHAR2 ) IS
13: CURSOR c_dup IS
14: SELECT 'Duplicate row found'
15: FROM gl_intercompany_acc_sets ia
16: WHERE ia.LEDGER_ID = x_ledger_id
17: AND ia.JE_SOURCE_NAME = x_je_source_name
18: AND ia.JE_CATEGORY_NAME = x_je_category_name
19: AND ( x_rowid IS NULL

Line 165: CURSOR C IS SELECT rowid FROM gl_intercompany_acc_sets

161: X_Attribute14 VARCHAR2,
162: X_Attribute15 VARCHAR2,
163: X_Context VARCHAR2
164: ) IS
165: CURSOR C IS SELECT rowid FROM gl_intercompany_acc_sets
166: WHERE je_source_name = X_Je_Source_Name
167: AND je_category_name = X_Je_Category_Name
168: AND ledger_id = X_Ledger_Id;
169:

Line 172: INSERT INTO gl_intercompany_acc_sets(

168: AND ledger_id = X_Ledger_Id;
169:
170: BEGIN
171:
172: INSERT INTO gl_intercompany_acc_sets(
173: je_source_name,
174: je_category_name,
175: ledger_id,
176: balance_by_code,

Line 281: FROM gl_intercompany_acc_sets

277: X_Context VARCHAR2
278: ) IS
279: CURSOR C IS
280: SELECT *
281: FROM gl_intercompany_acc_sets
282: WHERE rowid = X_Rowid
283: FOR UPDATE of Je_Source_Name NOWAIT;
284: Recinfo C%ROWTYPE;
285: BEGIN

Line 412: UPDATE gl_intercompany_acc_sets

408: X_Attribute15 VARCHAR2,
409: X_Context VARCHAR2
410: ) IS
411: BEGIN
412: UPDATE gl_intercompany_acc_sets
413: SET
414: je_source_name = X_Je_Source_Name,
415: je_category_name = X_Je_Category_Name,
416: ledger_id = X_Ledger_Id,

Line 461: DELETE FROM gl_intercompany_acc_sets

457: -- **********************************************************************
458:
459: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
460: BEGIN
461: DELETE FROM gl_intercompany_acc_sets
462: WHERE rowid = X_Rowid;
463:
464: if (SQL%NOTFOUND) then
465: RAISE NO_DATA_FOUND;