APPS.IGS_DA_CNFG_REQ_TYP_PKG dependencies on IGS_DA_CNFG_STAT

Line 275: igs_da_cnfg_stat_pkg.get_fk_igs_da_cnfg_req_typ (

271: igs_da_cnfg_ftr_pkg.get_fk_igs_da_cnfg_req_typ (
272: old_references.request_type_id
273: );
274:
275: igs_da_cnfg_stat_pkg.get_fk_igs_da_cnfg_req_typ (
276: old_references.request_type_id
277: );
278:
279: igs_da_rqst_pkg.get_fk_igs_da_cnfg_req_typ (

Line 1336: CURSOR cur_igs_da_cnfg_stat (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS

1332: FROM igs_da_cnfg_ftr
1333: WHERE request_type_id = cp_request_type_id;
1334:
1335:
1336: CURSOR cur_igs_da_cnfg_stat (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS
1337: SELECT
1338: rowid
1339: FROM igs_da_cnfg_stat
1340: WHERE request_type_id = cp_request_type_id;

Line 1339: FROM igs_da_cnfg_stat

1335:
1336: CURSOR cur_igs_da_cnfg_stat (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS
1337: SELECT
1338: rowid
1339: FROM igs_da_cnfg_stat
1340: WHERE request_type_id = cp_request_type_id;
1341:
1342: CURSOR cur_igs_da_cnfg (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS
1343: SELECT

Line 1351: l_cur_igs_da_cnfg_stat cur_igs_da_cnfg_stat%ROWTYPE;

1347:
1348:
1349: l_cur_parent_table cur_parent_table%ROWTYPE;
1350: l_cur_igs_da_cnfg_ftr cur_igs_da_cnfg_ftr%ROWTYPE;
1351: l_cur_igs_da_cnfg_stat cur_igs_da_cnfg_stat%ROWTYPE;
1352: l_cur_igs_da_cnfg cur_igs_da_cnfg%ROWTYPE;
1353:
1354:
1355: BEGIN

Line 1381: FOR l_cur_igs_da_cnfg_stat IN cur_igs_da_cnfg_stat(l_cur_parent_table.request_type_id) LOOP

1377: END LOOP;
1378:
1379:
1380:
1381: FOR l_cur_igs_da_cnfg_stat IN cur_igs_da_cnfg_stat(l_cur_parent_table.request_type_id) LOOP
1382:
1383: igs_da_cnfg_stat_pkg.delete_row (
1384: x_rowid => l_cur_igs_da_cnfg_stat.rowid
1385: );

Line 1383: igs_da_cnfg_stat_pkg.delete_row (

1379:
1380:
1381: FOR l_cur_igs_da_cnfg_stat IN cur_igs_da_cnfg_stat(l_cur_parent_table.request_type_id) LOOP
1382:
1383: igs_da_cnfg_stat_pkg.delete_row (
1384: x_rowid => l_cur_igs_da_cnfg_stat.rowid
1385: );
1386: END LOOP;
1387:

Line 1384: x_rowid => l_cur_igs_da_cnfg_stat.rowid

1380:
1381: FOR l_cur_igs_da_cnfg_stat IN cur_igs_da_cnfg_stat(l_cur_parent_table.request_type_id) LOOP
1382:
1383: igs_da_cnfg_stat_pkg.delete_row (
1384: x_rowid => l_cur_igs_da_cnfg_stat.rowid
1385: );
1386: END LOOP;
1387:
1388: