APPS.IGS_AD_GEN_001 dependencies on IGS_GR_AWD_CRMN_HIST

Line 1190: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS

1186:
1187: v_gua_del_exists c_gua_del%ROWTYPE;
1188:
1189: CURSOR c_gach (
1190: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS
1191: SELECT gach.gach_id
1192: FROM IGS_GR_AWD_CRMN_HIST gach
1193: WHERE gach.person_id = p_person_id AND
1194: gach.create_dt = cp_create_dt;

Line 1192: FROM IGS_GR_AWD_CRMN_HIST gach

1188:
1189: CURSOR c_gach (
1190: cp_create_dt IGS_GR_AWD_CRMN_HIST.create_dt%TYPE) IS
1191: SELECT gach.gach_id
1192: FROM IGS_GR_AWD_CRMN_HIST gach
1193: WHERE gach.person_id = p_person_id AND
1194: gach.create_dt = cp_create_dt;
1195: CURSOR c_gach_del (
1196: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS

Line 1196: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS

1192: FROM IGS_GR_AWD_CRMN_HIST gach
1193: WHERE gach.person_id = p_person_id AND
1194: gach.create_dt = cp_create_dt;
1195: CURSOR c_gach_del (
1196: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS
1197: SELECT rowid
1198: FROM IGS_GR_AWD_CRMN_HIST gach
1199: WHERE gach.gach_id = cp_gach_id
1200: FOR UPDATE OF gach.LAST_UPDATE_DATE NOWAIT ;

Line 1198: FROM IGS_GR_AWD_CRMN_HIST gach

1194: gach.create_dt = cp_create_dt;
1195: CURSOR c_gach_del (
1196: cp_gach_id IGS_GR_AWD_CRMN_HIST.gach_id%TYPE) IS
1197: SELECT rowid
1198: FROM IGS_GR_AWD_CRMN_HIST gach
1199: WHERE gach.gach_id = cp_gach_id
1200: FOR UPDATE OF gach.LAST_UPDATE_DATE NOWAIT ;
1201:
1202:

Line 1224: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records

1220:
1221: FOR v_gua_rec IN c_gua LOOP
1222: FOR v_gach_rec IN c_gach (v_gua_rec.create_dt) LOOP
1223: BEGIN
1224: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records
1225: FOR c_gach_del_rec in c_gach_del(
1226: v_gach_rec.gach_id) LOOP
1227:
1228: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(

Line 1228: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(

1224: -- Delete unconfirmed IGS_GR_AWD_CRMN_HIST records
1225: FOR c_gach_del_rec in c_gach_del(
1226: v_gach_rec.gach_id) LOOP
1227:
1228: IGS_GR_AWD_CRMN_HIST_PKG.DELETE_ROW(
1229: X_ROWID => c_gach_del_rec.ROWID );
1230:
1231: END LOOP;
1232: EXCEPTION

Line 1237: l_entity_name := 'IGS_GR_AWD_CRMN_HIST';

1233: WHEN e_resource_busy THEN
1234: IF c_gach_del%ISOPEN THEN
1235: CLOSE c_gach_del;
1236: END IF;
1237: l_entity_name := 'IGS_GR_AWD_CRMN_HIST';
1238: EXIT;
1239: END;
1240:
1241: END LOOP;