APPS.XLA_TAB_ATS_F_PKG dependencies on XLA_TAB_ACCT_TYPE_SRCS

Line 12: | Plsql table handler for table xla_tab_acct_type_srcs |

8: | PACKAGE NAME |
9: | xla_tab_ats_f_pkg |
10: | |
11: | DESCRIPTION |
12: | Plsql table handler for table xla_tab_acct_type_srcs |
13: | |
14: | HISTORY |
15: | 01-SEP-2005 Jorge Larre Initial Creation |
16: | |

Line 79: FROM xla_tab_acct_type_srcs

75: IS
76:
77: CURSOR c IS
78: SELECT rowid
79: FROM xla_tab_acct_type_srcs
80: WHERE application_id = x_application_id
81: AND account_type_code = x_account_type_code
82: AND source_application_id = x_source_application_id
83: AND source_type_code = x_source_type_code

Line 100: INSERT INTO xla_tab_acct_type_srcs

96: p_module => l_log_module,
97: p_level => C_LEVEL_PROCEDURE);
98: END IF;
99:
100: INSERT INTO xla_tab_acct_type_srcs
101: (creation_date
102: ,created_by
103: ,application_id
104: ,account_type_code

Line 204: UPDATE xla_tab_acct_type_srcs

200: p_module => l_log_module,
201: p_level => C_LEVEL_PROCEDURE);
202: END IF;
203:
204: UPDATE xla_tab_acct_type_srcs
205: SET
206: last_updated_by = x_last_updated_by
207: ,last_update_login = x_last_update_login
208: WHERE application_id = x_application_id

Line 253: DELETE FROM xla_tab_acct_type_srcs

249: p_module => l_log_module,
250: p_level => C_LEVEL_PROCEDURE);
251: END IF;
252:
253: DELETE FROM xla_tab_acct_type_srcs
254: WHERE application_id = x_application_id
255: AND account_type_code = x_account_type_code
256: AND source_application_id = x_source_application_id
257: AND source_type_code = x_source_type_code

Line 338: FROM xla_tab_acct_type_srcs

334: BEGIN
335:
336: SELECT last_updated_by, last_update_date
337: INTO db_luby, db_ludate
338: FROM xla_tab_acct_type_srcs
339: WHERE application_id = l_application_id
340: AND account_type_code = p_account_type_code
341: AND source_application_id = l_source_app_id
342: AND source_type_code = p_source_type_code