eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GE_GEN_003 dependencies on IGS_PE_STD_TODO

Line 12: knaraset 29-Apr-03 Added parameter p_uoo_id in procedure GENP_INS_TODO_REF and passed uoo_id in TBH calls of IGS_PE_STD_TODO_REF,

8: knaraset 14-Nov-2002 added get_person_id,get_program_version,get_calendar_instance,
9: get_susa_sequence_num as part of Build TD Legacy HESA SPA Bug 2661533
10: kumma 08-May-2003 2941138, Changed the procedure get_calendar_instance to not to use bind variable for cal_category
11: Bind variables should only be used for alternate code as cal_category is hard_coded in the caller and is not user enterable
12: knaraset 29-Apr-03 Added parameter p_uoo_id in procedure GENP_INS_TODO_REF and passed uoo_id in TBH calls of IGS_PE_STD_TODO_REF,
13: as part of MUS build bug 2829262
14: pkpatel 11-JUN-2003 Bug 2941138 (Closed the cursors cur_cal_cat_inst_cnt, cur_cal_cat_inst_dtls in procedure get_calendar_instance)
15: pkpatel 6-sep-2004 Bug 3868572 (Made the variable l_reference_number from NUMBER(7) to NUMBER)
16: */

Line 147: -- Create a 'todo' item for a student on the IGS_PE_STD_TODO table.

143: gv_other_details VARCHAR2(255);
144: l_rowid VARCHAR2(25);
145:
146: BEGIN -- genp_ins_stdnt_todo
147: -- Create a 'todo' item for a student on the IGS_PE_STD_TODO table.
148: -- The 'single entry' option, if flagged as Y indicates that if
149: -- an outstanding todo entry already exists (with an appropriate
150: -- todo date) then another isn't to be created.
151: -- The procedure was altered to a function to cater for returning

Line 152: -- the sequence number so that it can be used when inserting IGS_PE_STD_TODO_REF

148: -- The 'single entry' option, if flagged as Y indicates that if
149: -- an outstanding todo entry already exists (with an appropriate
150: -- todo date) then another isn't to be created.
151: -- The procedure was altered to a function to cater for returning
152: -- the sequence number so that it can be used when inserting IGS_PE_STD_TODO_REF
153: -- items for the todo item.
154: DECLARE
155: CURSOR c_st (
156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,

Line 156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,

152: -- the sequence number so that it can be used when inserting IGS_PE_STD_TODO_REF
153: -- items for the todo item.
154: DECLARE
155: CURSOR c_st (
156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
157: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
158: cp_todo_dt IGS_PE_STD_TODO.todo_dt%TYPE) IS
159: SELECT sequence_number
160: FROM IGS_PE_STD_TODO

Line 157: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,

153: -- items for the todo item.
154: DECLARE
155: CURSOR c_st (
156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
157: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
158: cp_todo_dt IGS_PE_STD_TODO.todo_dt%TYPE) IS
159: SELECT sequence_number
160: FROM IGS_PE_STD_TODO
161: WHERE person_id = cp_person_id AND

Line 158: cp_todo_dt IGS_PE_STD_TODO.todo_dt%TYPE) IS

154: DECLARE
155: CURSOR c_st (
156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
157: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
158: cp_todo_dt IGS_PE_STD_TODO.todo_dt%TYPE) IS
159: SELECT sequence_number
160: FROM IGS_PE_STD_TODO
161: WHERE person_id = cp_person_id AND
162: s_student_todo_type = cp_s_student_todo_type AND

Line 160: FROM IGS_PE_STD_TODO

156: cp_person_id IGS_PE_STD_TODO.person_id%TYPE,
157: cp_s_student_todo_type IGS_PE_STD_TODO.s_student_todo_type%TYPE,
158: cp_todo_dt IGS_PE_STD_TODO.todo_dt%TYPE) IS
159: SELECT sequence_number
160: FROM IGS_PE_STD_TODO
161: WHERE person_id = cp_person_id AND
162: s_student_todo_type = cp_s_student_todo_type AND
163: logical_delete_dt IS NULL AND
164: (todo_dt IS NULL OR

Line 167: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval

163: logical_delete_dt IS NULL AND
164: (todo_dt IS NULL OR
165: todo_dt <= cp_todo_dt);
166: CURSOR c_get_nxt_seq IS
167: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval
168: FROM DUAL;
169: v_st_rec c_st%ROWTYPE;
170: v_todo_compare IGS_PE_STD_TODO.todo_dt%TYPE;
171: v_sequence_num NUMBER;

Line 170: v_todo_compare IGS_PE_STD_TODO.todo_dt%TYPE;

166: CURSOR c_get_nxt_seq IS
167: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval
168: FROM DUAL;
169: v_st_rec c_st%ROWTYPE;
170: v_todo_compare IGS_PE_STD_TODO.todo_dt%TYPE;
171: v_sequence_num NUMBER;
172: BEGIN
173: IF (p_single_entry_ind = 'Y') THEN
174: IF (p_todo_dt IS NULL) THEN

Line 195: IGS_PE_STD_TODO_PKG.INSERT_ROW (

191: OPEN c_get_nxt_seq;
192: FETCH c_get_nxt_seq INTO v_sequence_num;
193: CLOSE c_get_nxt_seq;
194:
195: IGS_PE_STD_TODO_PKG.INSERT_ROW (
196: x_rowid => l_rowid ,
197: X_person_id =>p_person_id,
198: x_s_student_todo_type => p_s_student_todo_type,
199: x_sequence_number => v_sequence_num,

Line 331: v_str_record IGS_PE_STD_TODO_REF%ROWTYPE;

327: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54 );
328: gv_other_details VARCHAR2(255);
329: BEGIN
330: DECLARE
331: v_str_record IGS_PE_STD_TODO_REF%ROWTYPE;
332: v_message_name VARCHAR2(30);
333: v_exists_flag CHAR;
334: CURSOR c_lock_str_records IS
335: SELECT *

Line 336: FROM IGS_PE_STD_TODO_REF

332: v_message_name VARCHAR2(30);
333: v_exists_flag CHAR;
334: CURSOR c_lock_str_records IS
335: SELECT *
336: FROM IGS_PE_STD_TODO_REF
337: WHERE person_id = p_person_id AND
338: s_student_todo_type = p_s_student_todo_type AND
339: sequence_number = p_sequence_number AND
340: reference_number = p_reference_number

Line 348: FROM IGS_PE_STD_TODO_REF

344: SELECT 'x'
345: FROM dual
346: WHERE EXISTS (
347: SELECT person_id
348: FROM IGS_PE_STD_TODO_REF
349: WHERE person_id = p_person_id AND
350: s_student_todo_type = p_s_student_todo_type AND
351: sequence_number = p_sequence_number AND
352: logical_delete_dt IS NULL

Line 356: SELECT IGS_PE_STD_TODO_REF.* , ROWID

352: logical_delete_dt IS NULL
353: );
354: CURSOR SI_PE_TODO_REF_CUR
355: IS
356: SELECT IGS_PE_STD_TODO_REF.* , ROWID
357: FROM IGS_PE_STD_TODO_REF
358: WHERE person_id = p_person_id AND
359: s_student_todo_type = p_s_student_todo_type AND
360: sequence_number = p_sequence_number AND

Line 357: FROM IGS_PE_STD_TODO_REF

353: );
354: CURSOR SI_PE_TODO_REF_CUR
355: IS
356: SELECT IGS_PE_STD_TODO_REF.* , ROWID
357: FROM IGS_PE_STD_TODO_REF
358: WHERE person_id = p_person_id AND
359: s_student_todo_type = p_s_student_todo_type AND
360: sequence_number = p_sequence_number AND
361: reference_number = p_reference_number;

Line 366: -- Update the IGS_PE_STD_TODO_REF table with the NOWAIT option.

362:
363: BEGIN
364: -- Issue a save point so that if a lock occurs, the update can be rolled back.
365: SAVEPOINT sp_str_lgc_del;
366: -- Update the IGS_PE_STD_TODO_REF table with the NOWAIT option.
367: OPEN c_lock_str_records;
368: FETCH c_lock_str_records INTO v_str_record;
369: CLOSE c_lock_str_records;
370:

Line 373: IGS_PE_STD_TODO_REF_PKG.UPDATE_ROW(

369: CLOSE c_lock_str_records;
370:
371: FOR SI_RE_REC IN SI_PE_TODO_REF_CUR LOOP
372:
373: IGS_PE_STD_TODO_REF_PKG.UPDATE_ROW(
374: X_ROWID => SI_RE_REC.ROWID,
375: X_PERSON_ID => SI_RE_REC.PERSON_ID,
376: X_S_STUDENT_TODO_TYPE => SI_RE_REC.S_STUDENT_TODO_TYPE,
377: X_SEQUENCE_NUMBER => SI_RE_REC.SEQUENCE_NUMBER,

Line 389: -- Determine if there are any remaining IGS_PE_STD_TODO_REF records remaining to

385: X_MODE=> 'R',
386: X_UOO_ID => SI_RE_REC.UOO_ID
387: );
388: END LOOP;
389: -- Determine if there are any remaining IGS_PE_STD_TODO_REF records remaining to
390: -- be actioned and if not, then logically delete the IGS_PE_STD_TODO record.
391: OPEN c_chk_other_str_records;
392: FETCH c_chk_other_str_records INTO v_exists_flag;
393: IF c_chk_other_str_records%NOTFOUND THEN

Line 390: -- be actioned and if not, then logically delete the IGS_PE_STD_TODO record.

386: X_UOO_ID => SI_RE_REC.UOO_ID
387: );
388: END LOOP;
389: -- Determine if there are any remaining IGS_PE_STD_TODO_REF records remaining to
390: -- be actioned and if not, then logically delete the IGS_PE_STD_TODO record.
391: OPEN c_chk_other_str_records;
392: FETCH c_chk_other_str_records INTO v_exists_flag;
393: IF c_chk_other_str_records%NOTFOUND THEN
394: IF IGS_GE_GEN_004.genp_upd_st_lgc_del(p_person_id,

Line 441: SELECT 1 FROM IGS_PE_STD_TODO_REF WHERE

437:
438: DECLARE
439:
440: CURSOR c_dup IS
441: SELECT 1 FROM IGS_PE_STD_TODO_REF WHERE
442: PERSON_ID=P_PERSON_ID AND
443: S_STUDENT_TODO_TYPE=P_S_STUDENT_TODO_TYPE AND
444: SEQUENCE_NUMBER=P_SEQUENCE_NUMBER AND
445: ((CAL_TYPE = P_CAL_TYPE AND CAL_TYPE IS NOT NULL AND P_CAL_TYPE IS NOT NULL) OR (CAL_TYPE IS NULL AND P_CAL_TYPE IS NULL)) AND

Line 462: SELECT IGS_PE_STD_TODO_REF_RF_NUM_S.NEXTVAL INTO l_reference_number

458: FETCH c_dup INTO L_FLAG;
459: CLOSE c_dup;
460:
461: IF l_flag IS NULL THEN
462: SELECT IGS_PE_STD_TODO_REF_RF_NUM_S.NEXTVAL INTO l_reference_number
463: FROM DUAL;
464:
465: IGS_PE_STD_TODO_REF_PKG.INSERT_ROW (
466: x_rowid => l_rowid ,

Line 465: IGS_PE_STD_TODO_REF_PKG.INSERT_ROW (

461: IF l_flag IS NULL THEN
462: SELECT IGS_PE_STD_TODO_REF_RF_NUM_S.NEXTVAL INTO l_reference_number
463: FROM DUAL;
464:
465: IGS_PE_STD_TODO_REF_PKG.INSERT_ROW (
466: x_rowid => l_rowid ,
467: X_person_id =>p_person_id,
468: x_s_student_todo_type => p_s_student_todo_type,
469: x_sequence_number => p_sequence_number,