APPS.IGS_RU_GEN_003 dependencies on IGS_RU_LOV

Line 26: Delete from IGS_RU_LOV table

22: gv_other_detail VARCHAR2(255);
23: BEGIN
24: /*
25: rulp_del_rlov
26: Delete from IGS_RU_LOV table
27: */
28: DECLARE
29: e_resource_busy EXCEPTION;
30: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);

Line 37: FROM IGS_RU_LOV rlov

33: */
34:
35: CURSOR c_rlov_delete IS
36: SELECT rlov.rowid
37: FROM IGS_RU_LOV rlov
38: WHERE rlov.sequence_number = p_sequence_number
39: FOR UPDATE OF rlov.sequence_number NOWAIT;
40: BEGIN
41: p_message_name := null;

Line 46: IGS_RU_LOV_PKG.Delete_Row(

42: FOR v_rlov_delete_rec IN c_rlov_delete LOOP
43: /*
44: Delete current record
45: */
46: IGS_RU_LOV_PKG.Delete_Row(
47: X_ROWID => v_rlov_delete_rec.rowid
48: );
49: END LOOP;
50: /*

Line 327: v_lov_number IGS_RU_LOV.sequence_number%TYPE;

323: v_select_group IGS_RU_CALL.select_group%TYPE;
324: v_return_type IGS_RU_RET_TYPE.s_return_type%TYPE;
325: v_unprocessed VARCHAR2(2000);
326: v_rule_number IGS_RU_RULE.sequence_number%TYPE;
327: v_lov_number IGS_RU_LOV.sequence_number%TYPE;
328: v_other_details VARCHAR2(255);
329: e_parser_error EXCEPTION;
330: BEGIN
331: /*