APPS.JE_GR_IE_RULE_LINES_PKG dependencies on JE_GR_TRNOVR_RULE_LINES

Line 35: l_rule_line_id je_gr_trnovr_rule_lines.trnovr_rule_line_id%TYPE;

31: p_last_update_login IN NUMBER
32:
33: ) IS
34:
35: l_rule_line_id je_gr_trnovr_rule_lines.trnovr_rule_line_id%TYPE;
36:
37: debug_info VARCHAR2(250);
38: current_calling_sequence VARCHAR2(250);
39:

Line 51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;

47: 'JE_GR_IE_RULE_LINES_PKG.INSERT_ROW';
48:
49: debug_info := 'Get Rule Line ID from the Sequence';
50:
51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;
52:
53: debug_info := 'Insert row in je_gr_trnovr_rule_lines';
54:
55: INSERT INTO je_gr_trnovr_rule_lines (

Line 53: debug_info := 'Insert row in je_gr_trnovr_rule_lines';

49: debug_info := 'Get Rule Line ID from the Sequence';
50:
51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;
52:
53: debug_info := 'Insert row in je_gr_trnovr_rule_lines';
54:
55: INSERT INTO je_gr_trnovr_rule_lines (
56: trnovr_rule_line_id,
57: trnovr_rule_id,

Line 55: INSERT INTO je_gr_trnovr_rule_lines (

51: SELECT je_gr_trnovr_rule_lines_s.nextval INTO l_rule_line_id FROM dual;
52:
53: debug_info := 'Insert row in je_gr_trnovr_rule_lines';
54:
55: INSERT INTO je_gr_trnovr_rule_lines (
56: trnovr_rule_line_id,
57: trnovr_rule_id,
58: application_id,
59: lookup_type,

Line 114: FROM je_gr_trnovr_rule_lines

110: p_last_updated_by,
111: p_last_update_login
112: FROM DUAL
113: WHERE NOT EXISTS ( SELECT NULL
114: FROM je_gr_trnovr_rule_lines
115: WHERE trnovr_rule_id = p_rule_id
116: AND application_id = p_application_id
117: AND lookup_type = p_lookup_type
118: AND lookup_code = p_lookup_code);

Line 194: FROM je_gr_trnovr_rule_lines

190: attribute12,
191: attribute13,
192: attribute14,
193: attribute15
194: FROM je_gr_trnovr_rule_lines
195: WHERE trnovr_rule_line_id = p_rule_line_id
196: AND trnovr_rule_id = p_rule_id
197: AND application_id = p_application_id
198: FOR UPDATE OF trnovr_rule_line_id nowait;

Line 289: debug_info := 'Update row in je_gr_trnovr_rule_lines';

285: --
286: current_calling_sequence :=
287: 'JE_GR_IE_RULE_LINES_PKG.UPDATE_ROW';
288:
289: debug_info := 'Update row in je_gr_trnovr_rule_lines';
290:
291: UPDATE je_gr_trnovr_rule_lines
292: SET
293: lookup_type = p_lookup_type,

Line 291: UPDATE je_gr_trnovr_rule_lines

287: 'JE_GR_IE_RULE_LINES_PKG.UPDATE_ROW';
288:
289: debug_info := 'Update row in je_gr_trnovr_rule_lines';
290:
291: UPDATE je_gr_trnovr_rule_lines
292: SET
293: lookup_type = p_lookup_type,
294: lookup_code = p_lookup_code,
295: exclude_flag = p_exclude_flag,

Line 353: debug_info := 'delete row in je_gr_trnovr_rule_lines';

349: --
350: current_calling_sequence :=
351: 'JE_GR_IE_RULE_LINES_PKG.DELETE_ROW';
352:
353: debug_info := 'delete row in je_gr_trnovr_rule_lines';
354:
355: DELETE FROM je_gr_trnovr_rule_lines
356: WHERE trnovr_rule_id = p_rule_id
357: and trnovr_rule_line_id = p_rule_line_id;

Line 355: DELETE FROM je_gr_trnovr_rule_lines

351: 'JE_GR_IE_RULE_LINES_PKG.DELETE_ROW';
352:
353: debug_info := 'delete row in je_gr_trnovr_rule_lines';
354:
355: DELETE FROM je_gr_trnovr_rule_lines
356: WHERE trnovr_rule_id = p_rule_id
357: and trnovr_rule_line_id = p_rule_line_id;
358:
359: EXCEPTION