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.

[Home] [Help]

APPS.IGS_AD_GEN_001 dependencies on IGS_GR_AWD_CRMN

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 1205: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE) IS

1201:
1202:
1203:
1204: CURSOR c_gac (
1205: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE) IS
1206: SELECT gac.gac_id
1207: FROM IGS_GR_AWD_CRMN gac
1208: WHERE gac.person_id = p_person_id AND
1209: gac.create_dt = cp_create_dt;

Line 1207: FROM IGS_GR_AWD_CRMN gac

1203:
1204: CURSOR c_gac (
1205: cp_create_dt IGS_GR_AWD_CRMN.create_dt%TYPE) IS
1206: SELECT gac.gac_id
1207: FROM IGS_GR_AWD_CRMN gac
1208: WHERE gac.person_id = p_person_id AND
1209: gac.create_dt = cp_create_dt;
1210: CURSOR c_gac_del (
1211: cp_gac_id IGS_GR_AWD_CRMN.gac_id%TYPE) IS

Line 1211: cp_gac_id IGS_GR_AWD_CRMN.gac_id%TYPE) IS

1207: FROM IGS_GR_AWD_CRMN gac
1208: WHERE gac.person_id = p_person_id AND
1209: gac.create_dt = cp_create_dt;
1210: CURSOR c_gac_del (
1211: cp_gac_id IGS_GR_AWD_CRMN.gac_id%TYPE) IS
1212: SELECT rowid
1213: FROM IGS_GR_AWD_CRMN gac
1214: WHERE gac.gac_id = cp_gac_id
1215: FOR UPDATE OF gac.LAST_UPDATE_DATE NOWAIT ;

Line 1213: FROM IGS_GR_AWD_CRMN gac

1209: gac.create_dt = cp_create_dt;
1210: CURSOR c_gac_del (
1211: cp_gac_id IGS_GR_AWD_CRMN.gac_id%TYPE) IS
1212: SELECT rowid
1213: FROM IGS_GR_AWD_CRMN gac
1214: WHERE gac.gac_id = cp_gac_id
1215: FOR UPDATE OF gac.LAST_UPDATE_DATE NOWAIT ;
1216:
1217:

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;

Line 1248: -- Delete unconfirmed IGS_GR_AWD_CRMN records

1244: END IF;
1245:
1246: FOR v_gca_rec IN c_gac(v_gua_rec.create_dt) LOOP
1247: BEGIN
1248: -- Delete unconfirmed IGS_GR_AWD_CRMN records
1249: FOR c_gac_del_rec IN c_gac_del(
1250: v_gca_rec.gac_id) LOOP
1251:
1252: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(

Line 1252: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(

1248: -- Delete unconfirmed IGS_GR_AWD_CRMN records
1249: FOR c_gac_del_rec IN c_gac_del(
1250: v_gca_rec.gac_id) LOOP
1251:
1252: IGS_GR_AWD_CRMN_PKG.DELETE_ROW(
1253: X_ROWID => c_gac_del_rec.ROWID );
1254:
1255: END LOOP;
1256: EXCEPTION

Line 1261: l_entity_name := 'IGS_GR_AWD_CRMN';

1257: WHEN e_resource_busy THEN
1258: IF c_gac_del%ISOPEN THEN
1259: CLOSE c_gac_del;
1260: END IF;
1261: l_entity_name := 'IGS_GR_AWD_CRMN';
1262: EXIT;
1263: END;
1264: END LOOP;
1265: