APPS.ZX_AR_FORMULA_MIG_PKG dependencies on ZX_PROCESS_RESULTS

Line 39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;

35:
36: l_discount_flag CHAR;
37: l_charge_flag CHAR;
38:
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;

Line 1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *

1032:
1033: /****************************************************************************************
1034: * Procedure: CREATE_RULES *
1035: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *
1036: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1037: *****************************************************************************************/
1038:
1039: PROCEDURE CREATE_RULES
1040: ( --parameters rqrd for zx_rules_b

Line 1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results

1042: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE,
1043: p_effective_from IN ar_vat_tax_all.start_date%TYPE,
1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,

Line 1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,

1044: p_effective_to IN ar_vat_tax_all.end_date%TYPE,
1045: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE,
1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 1221: -- Inserting values in table zx_process_results

1217: RETURN;
1218: END;
1219: -- Bug 8429806
1220:
1221: -- Inserting values in table zx_process_results
1222:
1223: BEGIN
1224:
1225: INSERT INTO zx_process_results

Line 1225: INSERT INTO zx_process_results

1221: -- Inserting values in table zx_process_results
1222:
1223: BEGIN
1224:
1225: INSERT INTO zx_process_results
1226: (condition_group_code,
1227: priority,
1228: result_type_code,
1229: tax_status_code,

Line 1283: zx_process_results_s.NEXTVAL,

1279: 'N',
1280: 'N',
1281: 'MIGRATED',
1282: NULL,
1283: zx_process_results_s.NEXTVAL,
1284: p_content_owner_id, -- also used in insert of zx_rules_b also
1285: p_condition_group_id,
1286: l_tax_rule_id, -- zx_rules_b.tax_rule_id(based on rule created above)8429806
1287: p_tax_condition_id, --condition set id

Line 1303: FROM zx_process_results

1299: FROM dual
1300: WHERE
1301: --Re-runnability
1302: NOT EXISTS (SELECT 1
1303: FROM zx_process_results
1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806
1305: AND zx_process_results.content_owner_id = p_content_owner_id
1306: AND zx_process_results.condition_group_code = p_condition_grp_cd
1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result

Line 1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806

1300: WHERE
1301: --Re-runnability
1302: NOT EXISTS (SELECT 1
1303: FROM zx_process_results
1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806
1305: AND zx_process_results.content_owner_id = p_content_owner_id
1306: AND zx_process_results.condition_group_code = p_condition_grp_cd
1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1308: );

Line 1305: AND zx_process_results.content_owner_id = p_content_owner_id

1301: --Re-runnability
1302: NOT EXISTS (SELECT 1
1303: FROM zx_process_results
1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806
1305: AND zx_process_results.content_owner_id = p_content_owner_id
1306: AND zx_process_results.condition_group_code = p_condition_grp_cd
1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1308: );
1309:

Line 1306: AND zx_process_results.condition_group_code = p_condition_grp_cd

1302: NOT EXISTS (SELECT 1
1303: FROM zx_process_results
1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806
1305: AND zx_process_results.content_owner_id = p_content_owner_id
1306: AND zx_process_results.condition_group_code = p_condition_grp_cd
1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1308: );
1309:
1310:

Line 1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result

1303: FROM zx_process_results
1304: WHERE zx_process_results.tax_rule_id = l_tax_rule_id --Bug 8429806
1305: AND zx_process_results.content_owner_id = p_content_owner_id
1306: AND zx_process_results.condition_group_code = p_condition_grp_cd
1307: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1308: );
1309:
1310:
1311: EXCEPTION WHEN OTHERS THEN