APPS.IGS_AD_IMP_003 dependencies on IGS_AD_APP_REQ

Line 1554: AND NOT EXISTS (SELECT 1 FROM igs_ad_app_req b

1550: WHERE interface_run_id = p_interface_run_id
1551: AND status = '2'
1552: AND (
1553: ( NVL(match_ind,'15') = '15'
1554: AND NOT EXISTS (SELECT 1 FROM igs_ad_app_req b
1555: WHERE b.person_id = a.person_id
1556: AND b.admission_appl_number = a.admission_appl_number
1557: AND b.applicant_fee_type = a.applicant_fee_type_id
1558: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1574: AND EXISTS ( SELECT 1 FROM igs_ad_app_req b

1570: AND (
1571: (p_rule = 'I')
1572: OR (p_rule = 'R' AND match_ind = '21')
1573: )
1574: AND EXISTS ( SELECT 1 FROM igs_ad_app_req b
1575: WHERE b.person_id = a.person_id
1576: AND b.admission_appl_number = a.admission_appl_number
1577: AND b.applicant_fee_type = a.applicant_fee_type_id
1578: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1584: FROM igs_ad_app_req appreq

1580: );
1581:
1582: CURSOR c_dup_recd (l_fee_int_rec c_appl_fee%ROWTYPE) IS
1583: SELECT rowid, appreq.*
1584: FROM igs_ad_app_req appreq
1585: WHERE person_id = l_fee_int_rec.person_id
1586: AND admission_appl_number = l_fee_int_rec.admission_appl_number
1587: AND applicant_fee_type = l_fee_int_rec.applicant_fee_type_id
1588: AND applicant_fee_status = l_fee_int_rec.applicant_fee_status_id

Line 1652: AND 1 < (SELECT COUNT (*) FROM igs_ad_app_req b

1648: ,error_code = 'E681',
1649: error_text = l_error_text1
1650: WHERE interface_run_id = p_interface_run_id
1651: AND status = '2'
1652: AND 1 < (SELECT COUNT (*) FROM igs_ad_app_req b
1653: WHERE b.person_id = a.person_id
1654: AND b.admission_appl_number = a.admission_appl_number
1655: AND b.applicant_fee_type = a.applicant_fee_type_id
1656: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1668: AND EXISTS ( SELECT 1 FROM igs_ad_app_req b

1664: error_text = NULL,
1665: match_ind = '19'
1666: WHERE interface_run_id = p_interface_run_id
1667: AND status = '2'
1668: AND EXISTS ( SELECT 1 FROM igs_ad_app_req b
1669: WHERE b.person_id = a.person_id
1670: AND b.admission_appl_number = a.admission_appl_number
1671: AND b.applicant_fee_type = a.applicant_fee_type_id
1672: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1683: igs_ad_app_req_pkg.insert_row(

1679: SAVEPOINT fee_int_save;
1680:
1681: IF l_fee_int_rec.dmlmode = cst_insert THEN
1682: l_rowid := NULL;
1683: igs_ad_app_req_pkg.insert_row(
1684: x_rowid => l_rowid,
1685: x_app_req_id => l_app_req_id,
1686: x_person_id => l_fee_int_rec.person_id,
1687: x_admission_appl_number => l_fee_int_rec.admission_appl_number,

Line 1715: igs_ad_app_req_pkg.update_row(

1711: ELSIF l_fee_int_rec.dmlmode = cst_update THEN
1712: OPEN c_dup_recd(l_fee_int_rec);
1713: FETCH c_dup_recd INTO l_dup_recd;
1714: CLOSE c_dup_recd ;
1715: igs_ad_app_req_pkg.update_row(
1716: x_rowid => l_dup_recd.rowid,
1717: x_app_req_id => l_dup_recd.app_req_id,
1718: x_person_id => l_fee_int_rec.PERSON_ID,
1719: x_admission_appl_numbeR => l_fee_int_rec.admission_appl_number,

Line 1826: SELECT rowid FROM igs_ad_app_req b

1822: WHERE interface_run_id = p_interface_run_id
1823: AND p_rule = 'R'
1824: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
1825: AND EXISTS (
1826: SELECT rowid FROM igs_ad_app_req b
1827: WHERE b.person_id = a.person_id
1828: AND b.admission_appl_number = a.admission_appl_number
1829: AND b.applicant_fee_type = a.applicant_fee_type_id
1830: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1841: , dup_app_req_id = ( SELECT APP_REQ_ID FROM igs_ad_app_req b

1837: UPDATE igs_ad_fee_int a
1838: SET
1839: status = cst_s_val_3
1840: , match_ind = cst_mi_val_20
1841: , dup_app_req_id = ( SELECT APP_REQ_ID FROM igs_ad_app_req b
1842: WHERE b.person_id = a.person_id
1843: AND b.admission_appl_number = a.admission_appl_number
1844: AND b.applicant_fee_type = a.applicant_fee_type_id
1845: AND b.applicant_fee_status = a.applicant_fee_status_id

Line 1850: AND EXISTS ( SELECT rowid FROM igs_ad_app_req b

1846: AND TRUNC(b.fee_date) = TRUNC(a.fee_date))
1847: WHERE interface_run_id = p_interface_run_id
1848: AND status = cst_s_val_2
1849: AND NVL (match_ind, cst_mi_val_15) = cst_mi_val_15
1850: AND EXISTS ( SELECT rowid FROM igs_ad_app_req b
1851: WHERE b.person_id = a.person_id
1852: AND b.admission_appl_number = a.admission_appl_number
1853: AND b.applicant_fee_type = a.applicant_fee_type_id
1854: AND b.applicant_fee_status = a.applicant_fee_status_id