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:
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 (
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,
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,
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;
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:
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,
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,
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;
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