APPS.JE_GR_IE_RULES_PKG dependencies on JE_GR_TRNOVR_RULES

Line 33: l_rule_id je_gr_trnovr_rules.trnovr_rule_id%TYPE;

29: p_last_updated_by IN NUMBER,
30: p_last_update_login IN NUMBER,
31: p_legal_entity_id IN NUMBER) IS
32:
33: l_rule_id je_gr_trnovr_rules.trnovr_rule_id%TYPE;
34:
35: debug_info VARCHAR2(250);
36: current_calling_sequence VARCHAR2(250);
37:

Line 48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;

44: 'JE_GR_IE_RULES_PKG.INSERT_ROW';
45:
46: debug_info := 'Get Rule ID from the Sequence';
47:
48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;
49:
50: debug_info := 'Insert row in je_gr_trnovr_rules';
51:
52: INSERT INTO JE_GR_TRNOVR_RULES (

Line 50: debug_info := 'Insert row in je_gr_trnovr_rules';

46: debug_info := 'Get Rule ID from the Sequence';
47:
48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;
49:
50: debug_info := 'Insert row in je_gr_trnovr_rules';
51:
52: INSERT INTO JE_GR_TRNOVR_RULES (
53: application_id,
54: trnovr_rule_id,

Line 52: INSERT INTO JE_GR_TRNOVR_RULES (

48: SELECT je_gr_trnovr_rules_s.nextval INTO l_rule_id FROM dual;
49:
50: debug_info := 'Insert row in je_gr_trnovr_rules';
51:
52: INSERT INTO JE_GR_TRNOVR_RULES (
53: application_id,
54: trnovr_rule_id,
55: trnovr_rule_name,
56: enabled_flag,

Line 111: FROM je_gr_trnovr_rules

107: p_last_update_login,
108: p_legal_entity_id
109: FROM DUAL
110: WHERE NOT EXISTS ( SELECT NULL
111: FROM je_gr_trnovr_rules
112: WHERE application_id = p_application_id
113: AND trnovr_rule_name = p_rule_name);
114:
115: p_rule_id := l_rule_id;

Line 174: FROM je_gr_trnovr_rules

170: SELECT
171: trnovr_rule_name,
172: description,
173: enabled_flag
174: FROM je_gr_trnovr_rules
175: WHERE trnovr_rule_id = p_rule_id
176: AND application_id = p_application_id
177: FOR UPDATE OF trnovr_rule_id nowait;
178:

Line 244: debug_info := 'Update row in je_gr_trnovr_rules';

240: current_calling_sequence :=
241: 'JE_GR_IE_RULES_PKG.UPDATE_ROW';
242:
243:
244: debug_info := 'Update row in je_gr_trnovr_rules';
245:
246: UPDATE je_gr_trnovr_rules
247: SET
248: trnovr_rule_name = p_rule_name,

Line 246: UPDATE je_gr_trnovr_rules

242:
243:
244: debug_info := 'Update row in je_gr_trnovr_rules';
245:
246: UPDATE je_gr_trnovr_rules
247: SET
248: trnovr_rule_name = p_rule_name,
249: description = p_description,
250: enabled_flag = p_enabled_flag,

Line 317: debug_info := 'delete row in je_gr_trnovr_rules';

313:
314: DELETE FROM je_gr_trnovr_rule_lines
315: WHERE trnovr_rule_id = p_rule_id;
316:
317: debug_info := 'delete row in je_gr_trnovr_rules';
318:
319: DELETE FROM je_gr_trnovr_rules
320: WHERE application_id = p_application_id
321: AND trnovr_rule_id = p_rule_id;

Line 319: DELETE FROM je_gr_trnovr_rules

315: WHERE trnovr_rule_id = p_rule_id;
316:
317: debug_info := 'delete row in je_gr_trnovr_rules';
318:
319: DELETE FROM je_gr_trnovr_rules
320: WHERE application_id = p_application_id
321: AND trnovr_rule_id = p_rule_id;
322:
323: EXCEPTION