APPS.IGS_GE_GEN_004 dependencies on IGS_PE_STD_TODO

Line 87: v_st_record IGS_PE_STD_TODO%ROWTYPE;

83: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54 );
84: gv_other_details VARCHAR2(255);
85: BEGIN
86: DECLARE
87: v_st_record IGS_PE_STD_TODO%ROWTYPE;
88: CURSOR c_lock_st_records IS
89: SELECT *
90: FROM IGS_PE_STD_TODO
91: WHERE person_id = p_person_id AND

Line 90: FROM IGS_PE_STD_TODO

86: DECLARE
87: v_st_record IGS_PE_STD_TODO%ROWTYPE;
88: CURSOR c_lock_st_records IS
89: SELECT *
90: FROM IGS_PE_STD_TODO
91: WHERE person_id = p_person_id AND
92: s_student_todo_type = p_s_student_todo_type AND
93: sequence_number = p_sequence_number
94: FOR UPDATE

Line 97: SELECT IGS_PE_STD_TODO.* , ROWID

93: sequence_number = p_sequence_number
94: FOR UPDATE
95: NOWAIT;
96: CURSOR SI_PE_TODO_CUR IS
97: SELECT IGS_PE_STD_TODO.* , ROWID
98: FROM IGS_PE_STD_TODO
99: WHERE person_id = p_person_id AND
100: s_student_todo_type = p_s_student_todo_type AND
101: sequence_number = p_sequence_number;

Line 98: FROM IGS_PE_STD_TODO

94: FOR UPDATE
95: NOWAIT;
96: CURSOR SI_PE_TODO_CUR IS
97: SELECT IGS_PE_STD_TODO.* , ROWID
98: FROM IGS_PE_STD_TODO
99: WHERE person_id = p_person_id AND
100: s_student_todo_type = p_s_student_todo_type AND
101: sequence_number = p_sequence_number;
102:

Line 105: -- Update the IGS_PE_STD_TODO table with the NOWAIT option.

101: sequence_number = p_sequence_number;
102:
103:
104: BEGIN
105: -- Update the IGS_PE_STD_TODO table with the NOWAIT option.
106: OPEN c_lock_st_records;
107: FETCH c_lock_st_records INTO v_st_record;
108: CLOSE c_lock_st_records;
109: FOR SI_RE_REC IN SI_PE_TODO_CUR LOOP

Line 110: IGS_PE_STD_TODO_PKG.UPDATE_ROW(

106: OPEN c_lock_st_records;
107: FETCH c_lock_st_records INTO v_st_record;
108: CLOSE c_lock_st_records;
109: FOR SI_RE_REC IN SI_PE_TODO_CUR LOOP
110: IGS_PE_STD_TODO_PKG.UPDATE_ROW(
111: x_rowid => SI_RE_REC.ROWID ,
112: X_PERSON_ID => SI_RE_REC.PERSON_ID,
113: X_S_STUDENT_TODO_TYPE => SI_RE_REC.S_STUDENT_TODO_TYPE,
114: X_SEQUENCE_NUMBER => SI_RE_REC.SEQUENCE_NUMBER,