APPS.GL_AUTOPOST_OPTIONS_PKG dependencies on GL_AUTOMATIC_POSTING_OPTIONS

Line 17: FROM GL_AUTOMATIC_POSTING_OPTIONS apo

13: x_category_name VARCHAR2,
14: row_id VARCHAR2) IS
15: CURSOR chk_duplicates is
16: SELECT 'Duplicate'
17: FROM GL_AUTOMATIC_POSTING_OPTIONS apo
18: WHERE apo.autopost_set_id = x_autopost_set_id
19: AND apo.ledger_id = x_ledger_id
20: AND apo.actual_flag = x_actual_flag
21: AND apo.period_name = x_period_name

Line 79: CURSOR C IS SELECT rowid FROM GL_AUTOMATIC_POSTING_OPTIONS

75: X_Attribute14 VARCHAR2,
76: X_Attribute15 VARCHAR2,
77: X_Context VARCHAR2
78: ) IS
79: CURSOR C IS SELECT rowid FROM GL_AUTOMATIC_POSTING_OPTIONS
80: WHERE autopost_set_id = X_autopost_set_id
81: AND ledger_id = X_ledger_Id
82: AND actual_flag = X_Actual_Flag
83: AND period_name = X_Period_Name

Line 89: INSERT INTO GL_AUTOMATIC_POSTING_OPTIONS(

85: AND je_category_name = X_Je_Category_Name;
86:
87: BEGIN
88:
89: INSERT INTO GL_AUTOMATIC_POSTING_OPTIONS(
90: autopost_set_id,
91: ledger_id,
92: actual_flag,
93: period_name,

Line 186: FROM GL_AUTOMATIC_POSTING_OPTIONS

182: X_Context VARCHAR2
183: ) IS
184: CURSOR C IS
185: SELECT *
186: FROM GL_AUTOMATIC_POSTING_OPTIONS
187: WHERE rowid = X_Rowid
188: FOR UPDATE of autopost_set_id NOWAIT;
189: Recinfo C%ROWTYPE;
190: BEGIN

Line 305: UPDATE GL_AUTOMATIC_POSTING_OPTIONS

301: X_Attribute15 VARCHAR2,
302: X_Context VARCHAR2
303: ) IS
304: BEGIN
305: UPDATE GL_AUTOMATIC_POSTING_OPTIONS
306: SET
307:
308: autopost_set_id = X_Autopost_Set_Id,
309: ledger_id = X_Ledger_Id,

Line 345: DELETE FROM GL_AUTOMATIC_POSTING_OPTIONS

341:
342:
343: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
344: BEGIN
345: DELETE FROM GL_AUTOMATIC_POSTING_OPTIONS
346: WHERE rowid = X_Rowid;
347:
348: if (SQL%NOTFOUND) then
349: RAISE NO_DATA_FOUND;