APPS.XLA_PRODUCT_RULES_PKG dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 552: FROM xla_aad_hdr_acct_attrs

548: AND product_rule_type_code = p_product_rule_type_code
549: AND product_rule_code = p_product_rule_code;
550:
551: DELETE
552: FROM xla_aad_hdr_acct_attrs
553: WHERE application_id = p_application_id
554: AND amb_context_code = p_amb_context_code
555: AND product_rule_type_code = p_product_rule_type_code
556: AND product_rule_code = p_product_rule_code;

Line 620: FROM xla_aad_hdr_acct_attrs

616: AND event_class_code = p_event_class_code
617: AND event_type_code = p_event_type_code;
618:
619: DELETE
620: FROM xla_aad_hdr_acct_attrs
621: WHERE application_id = p_application_id
622: AND amb_context_code = p_amb_context_code
623: AND product_rule_type_code = p_product_rule_type_code
624: AND product_rule_code = p_product_rule_code

Line 769: INSERT INTO xla_aad_hdr_acct_attrs

765: AND amb_context_code = p_amb_context_code
766: AND product_rule_type_code = p_old_product_rule_type_code
767: AND product_rule_code = p_old_product_rule_code;
768:
769: INSERT INTO xla_aad_hdr_acct_attrs
770: (application_id
771: ,amb_context_code
772: ,product_rule_type_code
773: ,product_rule_code

Line 802: FROM xla_aad_hdr_acct_attrs

798: ,l_created_by
799: ,l_last_update_date
800: ,l_last_updated_by
801: ,l_last_update_login
802: FROM xla_aad_hdr_acct_attrs
803: WHERE application_id = p_application_id
804: AND amb_context_code = p_amb_context_code
805: AND product_rule_type_code = p_old_product_rule_type_code
806: AND product_rule_code = p_old_product_rule_code;

Line 1267: FROM xla_aad_hdr_acct_attrs

1263:
1264: CURSOR c_acct_sources
1265: IS
1266: SELECT 'x'
1267: FROM xla_aad_hdr_acct_attrs
1268: WHERE application_id = p_application_id
1269: AND amb_context_code = p_amb_context_code
1270: AND product_rule_type_code = p_product_rule_type_code
1271: AND product_rule_code = p_product_rule_code

Line 1299: INSERT into xla_aad_hdr_acct_attrs(

1295: INTO l_exist;
1296: IF c_acct_sources%notfound THEN
1297: -- Insert accounting attributes of level 'EVT_CLASS_AAD' and 'AAD_ONLY'
1298: -- with null source mapping
1299: INSERT into xla_aad_hdr_acct_attrs(
1300: application_id
1301: ,amb_context_code
1302: ,product_rule_type_code
1303: ,product_rule_code

Line 1367: UPDATE xla_aad_hdr_acct_attrs

1363:
1364: IF l_arr_acct_attribute_code.COUNT > 0 THEN
1365: FORALL i IN l_arr_acct_attribute_code.FIRST..l_arr_acct_attribute_code.LAST
1366:
1367: UPDATE xla_aad_hdr_acct_attrs
1368: SET source_application_id = l_arr_source_application_id(i)
1369: ,source_type_code = l_arr_source_type_code(i)
1370: ,source_code = l_arr_source_code(i)
1371: WHERE application_id = p_application_id