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.ECE_RULES_PKG dependencies on ECE_PROCESS_RULES

Line 157: l_rule_type ece_process_rules.rule_type%TYPE;

153: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Process_Rules';
154: l_api_version_number CONSTANT NUMBER := 1.0;
155:
156: xProgress VARCHAR2(80);
157: l_rule_type ece_process_rules.rule_type%TYPE;
158: l_rule_id NUMBER;
159: l_action_code ece_process_rules.action_code%TYPE;
160: l_valid_rule VARCHAR2(1):= 'Y';
161: l_tp_detail_id NUMBER;

Line 159: l_action_code ece_process_rules.action_code%TYPE;

155:
156: xProgress VARCHAR2(80);
157: l_rule_type ece_process_rules.rule_type%TYPE;
158: l_rule_id NUMBER;
159: l_action_code ece_process_rules.action_code%TYPE;
160: l_valid_rule VARCHAR2(1):= 'Y';
161: l_tp_detail_id NUMBER;
162: l_violation_level VARCHAR2(10) := g_process_rule;
163: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;

Line 171: from ece_process_rules

167: CURSOR c_rule_info(
168: p_rule_type VARCHAR2,
169: p_transaction_type VARCHAR2) IS
170: select process_rule_id, action_code
171: from ece_process_rules
172: where transaction_type = p_transaction_type and
173: map_id = p_map_id and
174: rule_type = p_rule_type;
175:

Line 1857: l_action_code ece_process_rules.action_code%TYPE;

1853: l_stage_id NUMBER(15);
1854: l_document_id NUMBER(15);
1855: l_document_number ece_stage.document_number%TYPE;
1856: l_rule_id NUMBER;
1857: l_action_code ece_process_rules.action_code%TYPE;
1858: l_return_status VARCHAR2(20);
1859: var_exists BOOLEAN := FALSE;
1860: l_stack_pos NUMBER;
1861: l_plsql_pos NUMBER;

Line 1874: from ece_process_rules

1870: v_pcode VARCHAR2(10);
1871:
1872: CURSOR c_addr_rule IS
1873: select process_rule_id, action_code
1874: from ece_process_rules
1875: where transaction_type = l_transaction_type and
1876: map_id = l_map_id and
1877: rule_type = l_rule_type;
1878:

Line 2613: l_action_code ece_process_rules.action_code%TYPE;

2609: n_country_pos NUMBER := NULL;
2610: n_region1_pos NUMBER := NULL;
2611: n_region2_pos NUMBER := NULL;
2612: n_region3_pos NUMBER := NULL;
2613: l_action_code ece_process_rules.action_code%TYPE;
2614: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2615: l_address VARCHAR2(50) := 'ship to';
2616:
2617: BEGIN

Line 2791: l_action_code ece_process_rules.action_code%TYPE;

2787: n_country_pos NUMBER := NULL;
2788: n_region1_pos NUMBER := NULL;
2789: n_region2_pos NUMBER := NULL;
2790: n_region3_pos NUMBER := NULL;
2791: l_action_code ece_process_rules.action_code%TYPE;
2792: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2793: l_address VARCHAR2(50) := 'bill to';
2794:
2795: BEGIN

Line 2965: l_action_code ece_process_rules.action_code%TYPE;

2961: n_country_pos NUMBER := NULL;
2962: n_region1_pos NUMBER := NULL;
2963: n_region2_pos NUMBER := NULL;
2964: n_region3_pos NUMBER := NULL;
2965: l_action_code ece_process_rules.action_code%TYPE;
2966: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
2967: l_address VARCHAR2(50) := 'Sold to';
2968:
2969: BEGIN

Line 3143: l_action_code ece_process_rules.action_code%TYPE;

3139: n_country_pos NUMBER := NULL;
3140: n_region1_pos NUMBER := NULL;
3141: n_region2_pos NUMBER := NULL;
3142: n_region3_pos NUMBER := NULL;
3143: l_action_code ece_process_rules.action_code%TYPE;
3144: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3145: l_address VARCHAR2(50) := 'ship from';
3146:
3147: BEGIN

Line 3309: l_action_code ece_process_rules.action_code%TYPE;

3305: n_country_pos NUMBER := NULL;
3306: n_region1_pos NUMBER := NULL;
3307: n_region2_pos NUMBER := NULL;
3308: n_region3_pos NUMBER := NULL;
3309: l_action_code ece_process_rules.action_code%TYPE;
3310: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3311: l_address VARCHAR2(50) := 'bill from';
3312:
3313: BEGIN

Line 3475: l_action_code ece_process_rules.action_code%TYPE;

3471: n_country_pos NUMBER := NULL;
3472: n_region1_pos NUMBER := NULL;
3473: n_region2_pos NUMBER := NULL;
3474: n_region3_pos NUMBER := NULL;
3475: l_action_code ece_process_rules.action_code%TYPE;
3476: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3477: l_address VARCHAR2(50) := 'ship to intrmd';
3478:
3479: BEGIN

Line 3639: l_action_code ece_process_rules.action_code%TYPE;

3635: n_country_pos NUMBER := NULL;
3636: n_region1_pos NUMBER := NULL;
3637: n_region2_pos NUMBER := NULL;
3638: n_region3_pos NUMBER := NULL;
3639: l_action_code ece_process_rules.action_code%TYPE;
3640: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3641: l_address VARCHAR2(50) := 'ship to internal';
3642:
3643: BEGIN

Line 3793: l_action_code ece_process_rules.action_code%TYPE;

3789: n_country_pos NUMBER := NULL;
3790: n_region1_pos NUMBER := NULL;
3791: n_region2_pos NUMBER := NULL;
3792: n_region3_pos NUMBER := NULL;
3793: l_action_code ece_process_rules.action_code%TYPE;
3794: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3795: l_address VARCHAR2(50) := 'bill to internal';
3796:
3797: BEGIN

Line 3947: l_action_code ece_process_rules.action_code%TYPE;

3943: n_country_pos NUMBER := NULL;
3944: n_region1_pos NUMBER := NULL;
3945: n_region2_pos NUMBER := NULL;
3946: n_region3_pos NUMBER := NULL;
3947: l_action_code ece_process_rules.action_code%TYPE;
3948: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
3949: l_address VARCHAR2(50) := 'ship from internal';
3950:
3951: BEGIN

Line 4112: l_action_code ece_process_rules.action_code%TYPE;

4108: n_country_pos NUMBER := NULL;
4109: n_region1_pos NUMBER := NULL;
4110: n_region2_pos NUMBER := NULL;
4111: n_region3_pos NUMBER := NULL;
4112: l_action_code ece_process_rules.action_code%TYPE;
4113: l_ignore_flag ece_rule_violations.ignore_flag%TYPE;
4114: l_address VARCHAR2(50) := 'bill from internal';
4115:
4116: BEGIN

Line 4305: from ece_process_rules

4301: p_rule_type VARCHAR2,
4302: p_transaction_type VARCHAR2,
4303: p_map_id NUMBER) IS
4304: select process_rule_id, action_code
4305: from ece_process_rules
4306: where transaction_type = p_transaction_type and
4307: map_id = p_map_id and
4308: rule_type = p_rule_type;
4309: