APPS.XLA_POST_ACCT_PROGS_F_PKG dependencies on XLA_POST_ACCT_PROGS_B

Line 84: FROM xla_post_acct_progs_b

80: IS
81:
82: CURSOR c IS
83: SELECT rowid
84: FROM xla_post_acct_progs_b
85: WHERE program_code = x_program_code
86: AND program_owner_code = x_program_owner_code
87: ;
88:

Line 103: INSERT INTO xla_post_acct_progs_b

99: p_level => C_LEVEL_PROCEDURE);
100: END IF;
101:
102:
103: INSERT INTO xla_post_acct_progs_b
104: (creation_date
105: ,created_by
106: ,program_code
107: ,program_owner_code

Line 189: FROM xla_post_acct_progs_b

185: IS
186:
187: CURSOR c IS
188: SELECT application_id
189: FROM xla_post_acct_progs_b
190: WHERE program_code = x_program_code
191: AND program_owner_code = x_program_owner_code
192: FOR UPDATE OF application_id NOWAIT;
193:

Line 293: UPDATE xla_post_acct_progs_b

289: p_module => l_log_module,
290: p_level => C_LEVEL_PROCEDURE);
291: END IF;
292:
293: UPDATE xla_post_acct_progs_b
294: SET
295: last_update_date = x_last_update_date
296: ,application_id = x_application_id
297: ,last_updated_by = x_last_updated_by

Line 363: DELETE FROM xla_post_acct_progs_b

359: IF (SQL%NOTFOUND) THEN
360: RAISE NO_DATA_FOUND;
361: END IF;
362:
363: DELETE FROM xla_post_acct_progs_b
364: WHERE program_code = x_program_code
365: AND program_owner_code = x_program_owner_code;
366:
367:

Line 403: FROM xla_post_acct_progs_b b

399:
400: DELETE FROM xla_post_acct_progs_tl T
401: WHERE NOT EXISTS
402: (SELECT NULL
403: FROM xla_post_acct_progs_b b
404: WHERE b.program_code = t.program_code
405: AND b.program_owner_code = t.program_owner_code);
406:
407: UPDATE xla_post_acct_progs_tl t