APPS.XLA_EVENT_SOURCES_PKG dependencies on XLA_JLT_ACCT_ATTRS

Line 88: INSERT INTO xla_jlt_acct_attrs

84: EXIT WHEN c_class_line_types%notfound;
85:
86: BEGIN
87:
88: INSERT INTO xla_jlt_acct_attrs
89: (application_id
90: ,amb_context_code
91: ,event_class_code
92: ,accounting_line_type_code

Line 134: INSERT INTO xla_jlt_acct_attrs

130: EXIT WHEN c_class_line_types%notfound;
131:
132: BEGIN
133:
134: INSERT INTO xla_jlt_acct_attrs
135: (application_id
136: ,amb_context_code
137: ,event_class_code
138: ,accounting_line_type_code

Line 223: FROM xla_jlt_acct_attrs a

219: INTO l_acct_source;
220: EXIT WHEN c_acct_source%notfound;
221:
222: DELETE
223: FROM xla_jlt_acct_attrs a
224: WHERE a.application_id = p_application_id
225: AND a.accounting_attribute_code = l_acct_source.accounting_source_code
226: AND not exists (SELECT 'x'
227: FROM xla_event_sources e

Line 295: FROM xla_jlt_acct_attrs

291:
292: CURSOR c_line_assignment
293: IS
294: SELECT amb_context_code, accounting_line_type_code, accounting_line_code
295: FROM xla_jlt_acct_attrs
296: WHERE application_id = p_application_id
297: AND event_class_code = p_event_class_code
298: AND source_application_id = p_source_application_id
299: AND source_code = p_source_code

Line 313: l_amb_context_code xla_jlt_acct_attrs.amb_context_code%TYPE;

309: AND source_code = p_source_code
310: AND source_type_code = p_source_type_code;
311:
312: l_temp NUMBER;
313: l_amb_context_code xla_jlt_acct_attrs.amb_context_code%TYPE;
314: l_accounting_line_type_code xla_jlt_acct_attrs.accounting_line_type_code%TYPE;
315: l_accounting_line_code xla_jlt_acct_attrs.accounting_line_code%TYPE;
316: l_product_rule_type_code xla_aad_hdr_acct_attrs.product_rule_type_code%TYPE;
317: l_product_rule_code xla_aad_hdr_acct_attrs.product_rule_code%TYPE;

Line 314: l_accounting_line_type_code xla_jlt_acct_attrs.accounting_line_type_code%TYPE;

310: AND source_type_code = p_source_type_code;
311:
312: l_temp NUMBER;
313: l_amb_context_code xla_jlt_acct_attrs.amb_context_code%TYPE;
314: l_accounting_line_type_code xla_jlt_acct_attrs.accounting_line_type_code%TYPE;
315: l_accounting_line_code xla_jlt_acct_attrs.accounting_line_code%TYPE;
316: l_product_rule_type_code xla_aad_hdr_acct_attrs.product_rule_type_code%TYPE;
317: l_product_rule_code xla_aad_hdr_acct_attrs.product_rule_code%TYPE;
318: l_application_name varchar2(240);

Line 315: l_accounting_line_code xla_jlt_acct_attrs.accounting_line_code%TYPE;

311:
312: l_temp NUMBER;
313: l_amb_context_code xla_jlt_acct_attrs.amb_context_code%TYPE;
314: l_accounting_line_type_code xla_jlt_acct_attrs.accounting_line_type_code%TYPE;
315: l_accounting_line_code xla_jlt_acct_attrs.accounting_line_code%TYPE;
316: l_product_rule_type_code xla_aad_hdr_acct_attrs.product_rule_type_code%TYPE;
317: l_product_rule_code xla_aad_hdr_acct_attrs.product_rule_code%TYPE;
318: l_application_name varchar2(240);
319: