APPS.IGS_RU_GEN_002 dependencies on IGS_RU_LOV

Line 151: v_description IGS_RU_LOV.description%TYPE;

147:
148: */
149: FUNCTION LOV_item
150: RETURN VARCHAR2 IS
151: v_description IGS_RU_LOV.description%TYPE;
152: v_selectable IGS_RU_LOV.selectable%TYPE;
153: BEGIN
154: SELECT description,
155: selectable

Line 152: v_selectable IGS_RU_LOV.selectable%TYPE;

148: */
149: FUNCTION LOV_item
150: RETURN VARCHAR2 IS
151: v_description IGS_RU_LOV.description%TYPE;
152: v_selectable IGS_RU_LOV.selectable%TYPE;
153: BEGIN
154: SELECT description,
155: selectable
156: INTO v_description,

Line 158: FROM IGS_RU_LOV

154: SELECT description,
155: selectable
156: INTO v_description,
157: v_selectable
158: FROM IGS_RU_LOV
159: WHERE sequence_number = p_LOV_number;
160: IF v_selectable = 'Y'
161: THEN
162: RETURN v_description;

Line 177: v_help_text igs_ru_lov.help_text%TYPE;

173: */
174: PROCEDURE insert_LOV_tab
175: IS
176: X_ROWID VARCHAR2(25);
177: v_help_text igs_ru_lov.help_text%TYPE;
178: CURSOR C_RL IS
179: SELECT ROWID, rl.*
180: FROM IGS_RU_LOV rl
181: WHERE SEQUENCE_NUMBER = p_LOV_number ;

Line 180: FROM IGS_RU_LOV rl

176: X_ROWID VARCHAR2(25);
177: v_help_text igs_ru_lov.help_text%TYPE;
178: CURSOR C_RL IS
179: SELECT ROWID, rl.*
180: FROM IGS_RU_LOV rl
181: WHERE SEQUENCE_NUMBER = p_LOV_number ;
182:
183: BEGIN
184: IF p_LOV_number IS NULL

Line 186: SELECT IGS_RU_LOV_SEQ_NUM_S.nextval

182:
183: BEGIN
184: IF p_LOV_number IS NULL
185: THEN
186: SELECT IGS_RU_LOV_SEQ_NUM_S.nextval
187: INTO p_LOV_number
188: FROM DUAL;
189: END IF;
190:

Line 192: IGS_RU_LOV_PKG.DELETE_ROW (X_ROWID => C_RL_REC.ROWID );

188: FROM DUAL;
189: END IF;
190:
191: FOR C_RL_REC IN C_RL LOOP
192: IGS_RU_LOV_PKG.DELETE_ROW (X_ROWID => C_RL_REC.ROWID );
193: END LOOP;
194:
195:
196: FOR v_index IN 1 .. gv_LOV_index

Line 199: IGS_RU_LOV_PKG.INSERT_ROW (

195:
196: FOR v_index IN 1 .. gv_LOV_index
197: LOOP
198: BEGIN
199: IGS_RU_LOV_PKG.INSERT_ROW (
200: X_ROWID => X_ROWID,
201: X_SEQUENCE_NUMBER => p_LOV_number,
202: X_DESCRIPTION => LTRIM(RTRIM(gt_rule_LOV(v_index).select_item)),
203: X_HELP_TEXT => LTRIM(RTRIM(gt_rule_LOV(v_index).description)),

Line 212: UPDATE igs_ru_lov

208: /*
209: NULL;
210: order of descriptions (better this way)
211: */
212: UPDATE igs_ru_lov
213: SET help_text = LTRIM(RTRIM(gt_rule_LOV(v_index).description))
214: WHERE sequence_number = p_LOV_number
215: AND description = LTRIM(RTRIM(gt_rule_LOV(v_index).select_item));
216: