APPS.IGS_SV_UTIL dependencies on IGS_SV_BTCH_SUMMARY

Line 165: FROM igs_sv_btch_summary

161: IS
162: CURSOR c_check(cp_information_type VARCHAR2, cp_mutually_info_typ VARCHAR2)
163: IS
164: SELECT COUNT (*)
165: FROM igs_sv_btch_summary
166: WHERE batch_id = p_batch_id
167: AND person_id = p_person_id
168: AND ACTION_CODE IN (SELECT lookup_code
169: FROM igs_lookup_values

Line 246: UPDATE igs_sv_btch_summary

242: BEGIN
243: SAVEPOINT batch_sav_pnt;
244:
245: IF p_change_data = 'HOLD' THEN
246: UPDATE igs_sv_btch_summary
247: SET adm_action_code = 'HOLD',
248: last_update_date = SYSDATE,
249: last_update_login = fnd_global.user_id
250: WHERE summary_id = p_summary_id;

Line 301: from igs_sv_btch_summary where batch_id = p_batch_id and person_id = p_person_id )

297: TAG_CODE,
298: ADM_ACTION_CODE ,
299: OWNER_TABLE_NAME ,
300: OWNER_TABLE_IDENTIFIER
301: from igs_sv_btch_summary where batch_id = p_batch_id and person_id = p_person_id )
302:
303: LOOP
304: -- my_dbg('Inside IF TAG_CODE : ',c_data_rec.TAG_CODE);
305:

Line 306: UPDATE igs_sv_btch_summary

302:
303: LOOP
304: -- my_dbg('Inside IF TAG_CODE : ',c_data_rec.TAG_CODE);
305:
306: UPDATE igs_sv_btch_summary
307: SET batch_id = l_batch_id,
308: adm_action_code = c_data_rec.ADM_ACTION_CODE,
309: last_update_date = SYSDATE,
310: last_update_login = fnd_global.user_id

Line 335: UPDATE igs_sv_btch_summary

331: END LOOP;
332: END IF;
333: END IF;
334:
335: UPDATE igs_sv_btch_summary
336: SET batch_id = l_batch_id,
337: adm_action_code = 'SEND',
338: last_update_date = SYSDATE,
339: last_update_login = fnd_global.user_id

Line 410: FROM igs_sv_btch_summary

406:
407: CURSOR chk_rec_count_crsr (cp_person_id NUMBER, cp_batch_id NUMBER)
408: IS
409: SELECT COUNT (*)
410: FROM igs_sv_btch_summary
411: WHERE batch_id = cp_batch_id AND person_id = cp_person_id;
412:
413: BEGIN
414: OPEN batch_crsr (p_batch_id);