APPS.IGS_DA_CNFG_REQ_TYP_PKG dependencies on IGS_DA_CNFG_FTR

Line 271: igs_da_cnfg_ftr_pkg.get_fk_igs_da_cnfg_req_typ (

267: igs_da_cnfg_pkg.get_fk_igs_da_cnfg_req_typ (
268: old_references.request_type_id
269: );
270:
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 (

Line 1329: CURSOR cur_igs_da_cnfg_ftr (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS

1325: request_type_id
1326: FROM igs_da_cnfg_req_typ_v
1327: WHERE row_id = x_rowid;
1328:
1329: CURSOR cur_igs_da_cnfg_ftr (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS
1330: SELECT
1331: rowid
1332: FROM igs_da_cnfg_ftr
1333: WHERE request_type_id = cp_request_type_id;

Line 1332: FROM igs_da_cnfg_ftr

1328:
1329: CURSOR cur_igs_da_cnfg_ftr (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS
1330: SELECT
1331: rowid
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

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 1342: CURSOR cur_igs_da_cnfg (cp_request_type_id igs_da_cnfg_ftr.request_type_id%TYPE) IS

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
1344: rowid
1345: FROM igs_da_cnfg
1346: WHERE request_type_id = cp_request_type_id;

Line 1350: l_cur_igs_da_cnfg_ftr cur_igs_da_cnfg_ftr%ROWTYPE;

1346: WHERE request_type_id = cp_request_type_id;
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:

Line 1371: FOR l_cur_igs_da_cnfg_ftr IN cur_igs_da_cnfg_ftr(l_cur_parent_table.request_type_id) LOOP

1367: FETCH cur_parent_table INTO l_cur_parent_table;
1368: CLOSE cur_parent_table;
1369:
1370:
1371: FOR l_cur_igs_da_cnfg_ftr IN cur_igs_da_cnfg_ftr(l_cur_parent_table.request_type_id) LOOP
1372:
1373:
1374: igs_da_cnfg_ftr_pkg.delete_row (
1375: x_rowid => l_cur_igs_da_cnfg_ftr.rowid

Line 1374: igs_da_cnfg_ftr_pkg.delete_row (

1370:
1371: FOR l_cur_igs_da_cnfg_ftr IN cur_igs_da_cnfg_ftr(l_cur_parent_table.request_type_id) LOOP
1372:
1373:
1374: igs_da_cnfg_ftr_pkg.delete_row (
1375: x_rowid => l_cur_igs_da_cnfg_ftr.rowid
1376: );
1377: END LOOP;
1378:

Line 1375: x_rowid => l_cur_igs_da_cnfg_ftr.rowid

1371: FOR l_cur_igs_da_cnfg_ftr IN cur_igs_da_cnfg_ftr(l_cur_parent_table.request_type_id) LOOP
1372:
1373:
1374: igs_da_cnfg_ftr_pkg.delete_row (
1375: x_rowid => l_cur_igs_da_cnfg_ftr.rowid
1376: );
1377: END LOOP;
1378:
1379: