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.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 1000: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *

996:
997: /****************************************************************************************
998: * Procedure: CREATE_RULES *
999: * Based on the input parameters, row(s) would be created in to ZX_RULES_B, *
1000: * ZX_RULES_TL and ZX_PROCESS_RESULTS. *
1001: *****************************************************************************************/
1002:
1003: PROCEDURE CREATE_RULES
1004: ( --parameters rqrd for zx_rules_b

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

1006: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE ,
1007: p_effective_from IN ar_vat_tax_all.start_date%TYPE ,
1008: p_effective_to IN ar_vat_tax_all.end_date%TYPE ,
1009: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE ,
1010: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1011: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE ,
1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,

Line 1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,

1008: p_effective_to IN ar_vat_tax_all.end_date%TYPE ,
1009: p_enabled_flag IN ar_tax_group_codes.enabled_flag%TYPE ,
1010: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1011: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE ,
1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1015: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1016: x_return_status OUT NOCOPY VARCHAR2 ) IS

Line 1163: -- Inserting values in table zx_process_results

1159: x_return_status := FND_API.G_RET_STS_ERROR;
1160:
1161: END;
1162:
1163: -- Inserting values in table zx_process_results
1164:
1165: BEGIN
1166:
1167: INSERT INTO zx_process_results

Line 1167: INSERT INTO zx_process_results

1163: -- Inserting values in table zx_process_results
1164:
1165: BEGIN
1166:
1167: INSERT INTO zx_process_results
1168: (condition_group_code ,
1169: priority ,
1170: result_type_code ,
1171: tax_status_code ,

Line 1225: zx_process_results_s.NEXTVAL ,

1221: 'N' ,
1222: 'N' ,
1223: 'MIGRATED' ,
1224: NULL ,
1225: zx_process_results_s.NEXTVAL ,
1226: p_content_owner_id , -- also used in insert of zx_rules_b also
1227: p_condition_group_id ,
1228: zx_rules_b_s.CURRVAL , -- zx_rules_b.tax_rule_id(based on rule created above)
1229: p_tax_condition_id , --condition set id

Line 1246: FROM zx_process_results, zx_rules_b

1242: FROM dual
1243: WHERE
1244: --Re-runnability
1245: NOT EXISTS (SELECT 1
1246: FROM zx_process_results, zx_rules_b
1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id
1248: AND zx_process_results.content_owner_id = p_content_owner_id
1249: AND zx_process_results.condition_group_code = p_condition_grp_cd
1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result

Line 1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id

1243: WHERE
1244: --Re-runnability
1245: NOT EXISTS (SELECT 1
1246: FROM zx_process_results, zx_rules_b
1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id
1248: AND zx_process_results.content_owner_id = p_content_owner_id
1249: AND zx_process_results.condition_group_code = p_condition_grp_cd
1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1251: );

Line 1248: AND zx_process_results.content_owner_id = p_content_owner_id

1244: --Re-runnability
1245: NOT EXISTS (SELECT 1
1246: FROM zx_process_results, zx_rules_b
1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id
1248: AND zx_process_results.content_owner_id = p_content_owner_id
1249: AND zx_process_results.condition_group_code = p_condition_grp_cd
1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1251: );
1252:

Line 1249: AND zx_process_results.condition_group_code = p_condition_grp_cd

1245: NOT EXISTS (SELECT 1
1246: FROM zx_process_results, zx_rules_b
1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id
1248: AND zx_process_results.content_owner_id = p_content_owner_id
1249: AND zx_process_results.condition_group_code = p_condition_grp_cd
1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1251: );
1252:
1253:

Line 1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result

1246: FROM zx_process_results, zx_rules_b
1247: WHERE zx_process_results.tax_rule_id = zx_rules_b.tax_rule_id
1248: AND zx_process_results.content_owner_id = p_content_owner_id
1249: AND zx_process_results.condition_group_code = p_condition_grp_cd
1250: AND zx_process_results.alphanumeric_result = p_alphanumeric_result
1251: );
1252:
1253:
1254: EXCEPTION WHEN OTHERS THEN