APPS.GL_AUTOPOST_SETS_PKG dependencies on GL_AUTOMATIC_POSTING_SETS

Line 15: FROM GL_AUTOMATIC_POSTING_SETS sets

11: x_accounted_period_type VARCHAR2,
12: row_id VARCHAR2) IS
13: CURSOR chk_duplicates is
14: SELECT 'Duplicate'
15: FROM GL_AUTOMATIC_POSTING_SETS sets
16: WHERE sets.autopost_set_name = x_autopost_set_name
17: AND sets.chart_of_accounts_id = x_Chart_Of_Accounts_Id
18: AND sets.period_set_name = x_Period_Set_Name
19: AND sets.accounted_period_type = x_Accounted_Period_Type

Line 80: CURSOR C IS SELECT rowid FROM GL_AUTOMATIC_POSTING_SETS

76: X_Attribute14 VARCHAR2,
77: X_Attribute15 VARCHAR2,
78: X_Context VARCHAR2
79: ) IS
80: CURSOR C IS SELECT rowid FROM GL_AUTOMATIC_POSTING_SETS
81: WHERE autopost_set_id = X_autopost_set_id
82: AND autopost_set_name = X_autopost_set_name;
83:
84: CURSOR C2 IS SELECT gl_automatic_posting_sets_s.nextval FROM DUAL;

Line 84: CURSOR C2 IS SELECT gl_automatic_posting_sets_s.nextval FROM DUAL;

80: CURSOR C IS SELECT rowid FROM GL_AUTOMATIC_POSTING_SETS
81: WHERE autopost_set_id = X_autopost_set_id
82: AND autopost_set_name = X_autopost_set_name;
83:
84: CURSOR C2 IS SELECT gl_automatic_posting_sets_s.nextval FROM DUAL;
85:
86:
87: BEGIN
88:

Line 94: INSERT INTO GL_AUTOMATIC_POSTING_SETS(

90: OPEN C2;
91: FETCH C2 INTO X_autopost_set_id;
92: CLOSE C2;
93: end if;
94: INSERT INTO GL_AUTOMATIC_POSTING_SETS(
95: autopost_set_id,
96: autopost_set_name,
97: chart_of_accounts_id,
98: period_set_name,

Line 206: FROM GL_AUTOMATIC_POSTING_SETS

202: X_Context VARCHAR2
203: ) IS
204: CURSOR C IS
205: SELECT *
206: FROM GL_AUTOMATIC_POSTING_SETS
207: WHERE rowid = X_Rowid
208: FOR UPDATE of autopost_set_id NOWAIT;
209: Recinfo C%ROWTYPE;
210: BEGIN

Line 347: UPDATE GL_AUTOMATIC_POSTING_SETS

343: X_Attribute15 VARCHAR2,
344: X_Context VARCHAR2
345: ) IS
346: BEGIN
347: UPDATE GL_AUTOMATIC_POSTING_SETS
348: SET
349:
350: autopost_set_id = X_Autopost_Set_Id,
351: autopost_set_name = X_autopost_set_name,

Line 398: DELETE FROM GL_AUTOMATIC_POSTING_SETS

394: BEGIN
395: DELETE FROM GL_AUTOMATIC_POSTING_OPTIONS
396: WHERE autopost_set_id = X_Autopost_Set_Id;
397:
398: DELETE FROM GL_AUTOMATIC_POSTING_SETS
399: WHERE rowid = X_Rowid;
400:
401: if (SQL%NOTFOUND) then
402: RAISE NO_DATA_FOUND;