APPS.XLA_PRODUCT_RULES_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 566: FROM xla_prod_acct_headers

562: AND product_rule_type_code = p_product_rule_type_code
563: AND product_rule_code = p_product_rule_code;
564:
565: DELETE
566: FROM xla_prod_acct_headers
567: WHERE application_id = p_application_id
568: AND amb_context_code = p_amb_context_code
569: AND product_rule_type_code = p_product_rule_type_code
570: AND product_rule_code = p_product_rule_code;

Line 692: INSERT INTO xla_prod_acct_headers

688: l_created_by := xla_environment_pkg.g_usr_id;
689: l_last_update_login := xla_environment_pkg.g_login_id;
690: l_last_updated_by := xla_environment_pkg.g_usr_id;
691:
692: INSERT INTO xla_prod_acct_headers
693: (application_id
694: ,amb_context_code
695: ,product_rule_type_code
696: ,product_rule_code

Line 727: FROM xla_prod_acct_headers

723: ,l_created_by
724: ,l_last_update_date
725: ,l_last_updated_by
726: ,l_last_update_login
727: FROM xla_prod_acct_headers
728: WHERE application_id = p_application_id
729: AND amb_context_code = p_amb_context_code
730: AND product_rule_type_code = p_old_product_rule_type_code
731: AND product_rule_code = p_old_product_rule_code;

Line 1505: FROM xla_prod_acct_headers xpa

1501: CURSOR c_locked_aads IS
1502: SELECT xpa.entity_code, xpa.event_class_code, xpa.event_type_code,
1503: xpa.product_rule_type_code, xpa.product_rule_code,
1504: xpa.amb_context_code, xpa.locking_status_flag
1505: FROM xla_prod_acct_headers xpa
1506: WHERE xpa.application_id = p_application_id
1507: AND (xpa.validation_status_code NOT IN ('E', 'Y', 'N') OR
1508: xpa.locking_status_flag = 'Y');
1509:

Line 1554: UPDATE xla_prod_acct_headers xpa

1550: SET validation_status_code = 'N'
1551: WHERE xld.application_id = p_application_id
1552: AND xld.validation_status_code <> 'N';
1553:
1554: UPDATE xla_prod_acct_headers xpa
1555: SET validation_status_code = 'N'
1556: WHERE xpa.application_id = p_application_id
1557: AND xpa.validation_status_code <> 'N';
1558: