eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_EVT_CLASS_ACCT_ATTRS_PKG dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 747: , xla_aad_hdr_acct_attrs xah

743: ,xpa.product_rule_code
744: , xpa.validation_status_code
745: , xpa.locking_status_flag
746: FROM xla_prod_acct_headers xpa
747: , xla_aad_hdr_acct_attrs xah
748: WHERE xpa.application_id = xah.application_id
749: AND xpa.amb_context_code = xah.amb_context_code
750: AND xpa.event_class_code = xah.event_class_code
751: AND xpa.event_type_code = xah.event_type_code

Line 804: FROM xla_aad_hdr_acct_attrs xah

800: UPDATE xla_prod_acct_headers xpa
801: SET validation_status_code = 'N'
802: WHERE xpa.accounting_required_flag = 'Y'
803: AND EXISTS (SELECT 'x'
804: FROM xla_aad_hdr_acct_attrs xah
805: WHERE xpa.application_id = xah.application_id
806: AND xpa.amb_context_code = xah.amb_context_code
807: AND xpa.event_class_code = xah.event_class_code
808: AND xpa.event_type_code = xah.event_type_code

Line 818: , xla_aad_hdr_acct_attrs xah

814: SET compile_status_code = 'N'
815: WHERE xpr.compile_status_code <> 'N'
816: AND EXISTS (SELECT 'x'
817: FROM xla_prod_acct_headers xpa
818: , xla_aad_hdr_acct_attrs xah
819: WHERE xpa.application_id = xah.application_id
820: AND xpa.amb_context_code = xah.amb_context_code
821: AND xpa.event_class_code = xah.event_class_code
822: AND xpa.event_type_code = xah.event_type_code

Line 1418: , xla_aad_hdr_acct_attrs xah

1414: ,xpa.product_rule_code
1415: , xpa.validation_status_code
1416: , xpa.locking_status_flag
1417: FROM xla_prod_acct_headers xpa
1418: , xla_aad_hdr_acct_attrs xah
1419: WHERE xpa.application_id = xah.application_id
1420: AND xpa.amb_context_code = xah.amb_context_code
1421: AND xpa.product_rule_type_code = xah.product_rule_type_code
1422: AND xpa.product_rule_code = xah.product_rule_code

Line 1479: FROM xla_aad_hdr_acct_attrs xah

1475: UPDATE xla_prod_acct_headers xpa
1476: SET validation_status_code = 'N'
1477: WHERE xpa.accounting_required_flag = 'Y'
1478: AND EXISTS (SELECT 'X'
1479: FROM xla_aad_hdr_acct_attrs xah
1480: WHERE xpa.application_id = xah.application_id
1481: AND xpa.amb_context_code = xah.amb_context_code
1482: AND xpa.product_rule_type_code = xah.product_rule_type_code
1483: AND xpa.product_rule_code = xah.product_rule_code

Line 1497: , xla_aad_hdr_acct_attrs xah

1493: SET compile_status_code = 'N'
1494: WHERE xpr.compile_status_code <> 'N'
1495: AND EXISTS (SELECT 'x'
1496: FROM xla_prod_acct_headers xpa
1497: , xla_aad_hdr_acct_attrs xah
1498: WHERE xpa.application_id = xpr.application_id
1499: AND xpa.amb_context_code = xpr.amb_context_code
1500: AND xpa.product_rule_type_code = xpr.product_rule_type_code
1501: AND xpa.product_rule_code = xpr.product_rule_code

Line 2266: FROM xla_aad_hdr_acct_attrs

2262:
2263: CURSOR c_aad_assgn_exist
2264: IS
2265: SELECT 'x'
2266: FROM xla_aad_hdr_acct_attrs
2267: WHERE application_id = p_application_id
2268: AND event_class_code = p_event_class_code
2269: AND accounting_attribute_code = p_accounting_attribute_code;
2270:

Line 2305: INSERT INTO xla_aad_hdr_acct_attrs

2301: l_arr_product_rule_code, l_arr_event_type_code;
2302:
2303: IF l_arr_product_rule_code.COUNT > 0 THEN
2304: FORALL i IN l_arr_product_rule_code.FIRST..l_arr_product_rule_code.LAST
2305: INSERT INTO xla_aad_hdr_acct_attrs
2306: (application_id
2307: ,amb_context_code
2308: ,product_rule_type_code
2309: ,product_rule_code

Line 2357: UPDATE xla_aad_hdr_acct_attrs

2353:
2354: ELSE
2355:
2356: -- Update default assignments for AADs
2357: UPDATE xla_aad_hdr_acct_attrs
2358: SET source_application_id = p_source_application_id
2359: ,source_type_code = p_source_type_code
2360: ,source_code = p_source_code
2361: WHERE application_id = p_application_id

Line 2404: INSERT INTO xla_aad_hdr_acct_attrs

2400: l_arr_product_rule_code, l_arr_event_type_code;
2401:
2402: IF l_arr_product_rule_code.COUNT > 0 THEN
2403: FORALL i IN l_arr_product_rule_code.FIRST..l_arr_product_rule_code.LAST
2404: INSERT INTO xla_aad_hdr_acct_attrs
2405: (application_id
2406: ,amb_context_code
2407: ,product_rule_type_code
2408: ,product_rule_code

Line 2518: UPDATE xla_aad_hdr_acct_attrs

2514:
2515: IF p_default_flag = 'Y' THEN
2516:
2517: -- Update default assignments for AADs with the new source mapping
2518: UPDATE xla_aad_hdr_acct_attrs
2519: SET source_application_id = p_source_application_id
2520: ,source_type_code = p_source_type_code
2521: ,source_code = p_source_code
2522: WHERE application_id = p_application_id

Line 2555: UPDATE xla_aad_hdr_acct_attrs

2551: ,x_locking_status_flag => l_locking_status_flag
2552: ,x_validation_status_code => l_validation_status_code);
2553:
2554: -- Update default assignments for AADs with the null source mapping
2555: UPDATE xla_aad_hdr_acct_attrs
2556: SET source_application_id = NULL
2557: ,source_type_code = NULL
2558: ,source_code = NULL
2559: WHERE application_id = p_application_id

Line 2650: FROM xla_aad_hdr_acct_attrs

2646: IF l_count = 1 THEN
2647: -- it is the last assignment, so delete from AAD
2648:
2649: DELETE
2650: FROM xla_aad_hdr_acct_attrs
2651: WHERE application_id = p_application_id
2652: AND event_class_code = p_event_class_code
2653: AND accounting_attribute_code = p_accounting_attribute_code;
2654:

Line 2683: UPDATE xla_aad_hdr_acct_attrs

2679: ,x_event_type_name => l_event_type_name
2680: ,x_locking_status_flag => l_locking_status_flag);
2681:
2682: -- Update assignments for AADs with the null source mapping
2683: UPDATE xla_aad_hdr_acct_attrs
2684: SET source_application_id = NULL
2685: ,source_type_code = NULL
2686: ,source_code = NULL
2687: WHERE application_id = p_application_id