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.

APPS.IGS_AD_IMP_004 dependencies on IGS_AD_APL_INT

Line 263: FROM igs_ad_apl_int api

259:
260: CURSOR
261: appl_cur IS
262: SELECT cst_insert dmlmode, api.rowid, api.*
263: FROM igs_ad_apl_int api
264: WHERE api.interface_run_id = p_interface_run_id
265: AND api.status = '2'
266: AND ( p_rule = 'R' AND api.match_ind IN ('16', '25')
267: OR update_adm_appl_number IS NULL )

Line 270: FROM igs_ad_apl_int api

266: AND ( p_rule = 'R' AND api.match_ind IN ('16', '25')
267: OR update_adm_appl_number IS NULL )
268: UNION ALL
269: SELECT cst_update dmlmode, api.rowid, api.*
270: FROM igs_ad_apl_int api
271: WHERE api.interface_run_id = p_interface_run_id
272: AND api.status = '2'
273: AND ( p_rule = 'I' OR (p_rule = 'R' AND api.match_ind = '21'))
274: AND update_adm_appl_number IS NOT NULL ;

Line 278: appl_cur_upd( p_interface_appl_id igs_ad_apl_int.interface_appl_id%TYPE) IS

274: AND update_adm_appl_number IS NOT NULL ;
275:
276: -- To be used by instances where application already exists in OSS
277: CURSOR
278: appl_cur_upd( p_interface_appl_id igs_ad_apl_int.interface_appl_id%TYPE) IS
279: SELECT cst_update dmlmode, api.rowid, api.*
280: FROM igs_ad_apl_int api
281: WHERE api.interface_run_id = p_interface_run_id
282: AND interface_appl_id = p_interface_appl_id

Line 280: FROM igs_ad_apl_int api

276: -- To be used by instances where application already exists in OSS
277: CURSOR
278: appl_cur_upd( p_interface_appl_id igs_ad_apl_int.interface_appl_id%TYPE) IS
279: SELECT cst_update dmlmode, api.rowid, api.*
280: FROM igs_ad_apl_int api
281: WHERE api.interface_run_id = p_interface_run_id
282: AND interface_appl_id = p_interface_appl_id
283: AND status = cst_s_val_1;
284:

Line 287: cp_interface_appl_id igs_ad_apl_int.interface_appl_id%TYPE ) IS

283: AND status = cst_s_val_1;
284:
285: CURSOR
286: applinst_cur(
287: cp_interface_appl_id igs_ad_apl_int.interface_appl_id%TYPE ) IS
288: SELECT
289: cst_insert dmlmode, aplinst.rowid, aplinst.*
290: FROM
291: igs_ad_ps_appl_inst_int aplinst

Line 593: igs_ad_imp_001.logerrormessage(p_appl_rec.interface_appl_id,l_msg_data,'IGS_AD_APL_INT');

589: l_error_text := l_msg_data;
590: l_error_code := 'E322';
591: p_status := 'E';
592: IF p_enable_log = 'Y' THEN
593: igs_ad_imp_001.logerrormessage(p_appl_rec.interface_appl_id,l_msg_data,'IGS_AD_APL_INT');
594: END IF;
595: ELSE
596: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
597: l_error_code := 'E518';

Line 614: UPDATE IGS_AD_APL_INT

610: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
611: END IF;
612:
613: END IF;
614: UPDATE IGS_AD_APL_INT
615: SET status = cst_s_val_3,
616: error_code = l_error_code,
617: error_text = l_error_text,
618: match_ind = DECODE (

Line 677: igs_ad_apl_int

673: X_alt_appl_id => NVL(p_appl_rec.alt_appl_id, dup_cur_rec.alt_appl_id),
674: x_appl_fee_amt => NVL(p_appl_rec.appl_fee_amt, dup_cur_rec.appl_fee_amt)
675: );
676: UPDATE
677: igs_ad_apl_int
678: SET
679: status = cst_s_val_1,
680: admission_Appl_number = p_appl_rec.update_adm_appl_number,
681: acad_ci_sequence_number = NVL(p_appl_rec.Acad_Ci_Sequence_Number, dup_cur_rec.Acad_Ci_Sequence_Number),

Line 705: igs_ad_imp_001.logerrormessage(p_appl_rec.interface_appl_id,l_msg_data,'IGS_AD_APL_INT');

701: l_error_text := l_msg_data;
702: l_error_code := 'E014';
703:
704: IF p_enable_log = 'Y' THEN
705: igs_ad_imp_001.logerrormessage(p_appl_rec.interface_appl_id,l_msg_data,'IGS_AD_APL_INT');
706: END IF;
707: ELSE
708: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
709: l_error_code := 'E518';

Line 725: UPDATE IGS_AD_APL_INT

721: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
722: END IF;
723:
724: END IF;
725: UPDATE IGS_AD_APL_INT
726: SET status = cst_s_val_3,
727: error_code = l_error_code,
728: error_text = l_error_text,
729: match_ind = DECODE (

Line 745: PROCEDURE create_application_instance(p_interface_appl_id IGS_AD_APL_INT.interface_appl_id%TYPE,

741: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
742: p_appl_rec appl_cur%ROWTYPE,
743: p_Status OUT NOCOPY VARCHAR2) ;
744:
745: PROCEDURE create_application_instance(p_interface_appl_id IGS_AD_APL_INT.interface_appl_id%TYPE,
746: p_person_id hz_parties.party_id%TYPE,
747: p_admission_Appl_number IGS_AD_APPL.admission_appl_number%TYPE,
748: p_appl_rec appl_cur%ROWTYPE,
749: p_Status_instance OUT NOCOPY VARCHAR2) IS

Line 1659: UPDATE igs_ad_apl_int api

1655: l_debug_str, NULL,
1656: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1657: END IF;
1658:
1659: UPDATE igs_ad_apl_int api
1660: SET
1661: status = '3',
1662: error_code = 'E523',
1663: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E523', 8405)

Line 1674: UPDATE igs_ad_apl_int

1670: ) ;
1671: COMMIT;
1672: -- 1. Set STATUS to 3 for interface records with RULE = E or I and MATCH IND is not null and not '15'
1673: IF p_rule IN ('E', 'I') THEN
1674: UPDATE igs_ad_apl_int
1675: SET
1676: status = '3'
1677: , error_code = 'E700'
1678: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 1687: UPDATE igs_ad_apl_int

1683: COMMIT;
1684:
1685: -- 2. Set STATUS to 1 for interface records with RULE = R and MATCH IND = 17,18,19,22,23,24,27
1686: IF p_rule = 'R' THEN
1687: UPDATE igs_ad_apl_int
1688: SET
1689: status = '1'
1690: ,error_code = NULL
1691: ,error_text = NULL

Line 1700: UPDATE igs_ad_apl_int api

1696: COMMIT;
1697:
1698: -- 5. Set STATUS to 1 and MATCH IND to 19 for interface records with RULE = E matching OSS record(s)
1699: IF p_rule = 'E' THEN
1700: UPDATE igs_ad_apl_int api
1701: SET
1702: status = '1'
1703: , match_ind = '19'
1704: , admission_appl_number = update_adm_appl_number

Line 1712: UPDATE igs_ad_apl_int api

1708: END IF;
1709: COMMIT;
1710: -- Error out applications that need to be updated but they have legacy data
1711: IF p_legacy_ind = 'Y' THEN
1712: UPDATE igs_ad_apl_int api
1713: SET
1714: status = '3'
1715: ,error_code = 'E677'
1716: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E677', 8405)

Line 1728: UPDATE igs_ad_apl_int api

1724: );
1725: END IF;
1726: COMMIT;
1727:
1728: UPDATE igs_ad_apl_int api
1729: SET
1730: status = '3'
1731: ,error_code = 'E176'
1732: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E176', 8405)

Line 1770: igs_ad_apl_int

1766: l_admission_appl_number, appl_rec, l_Status_instance);
1767: IF l_Status_instance = 'E' THEN
1768: ROLLBACK to before_create_application;
1769: UPDATE
1770: igs_ad_apl_int
1771: SET
1772: status = '3',
1773: error_code = 'E347'
1774: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

Line 1779: igs_ad_apl_int

1775: WHERE
1776: interface_appl_id = appl_rec.interface_appl_id;
1777: ELSIF l_Status_instance = 'W' THEN
1778: UPDATE
1779: igs_ad_apl_int
1780: SET
1781: status = '4',
1782: error_code = 'E347'
1783: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)

Line 1788: igs_ad_apl_int

1784: WHERE
1785: interface_appl_id = appl_rec.interface_appl_id;
1786: ELSE
1787: UPDATE
1788: igs_ad_apl_int
1789: SET
1790: status = cst_s_val_1,
1791: admission_Appl_number = l_admission_appl_number
1792: WHERE

Line 1817: UPDATE igs_ad_apl_int api

1813: END IF;
1814: /*Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching OSS record(s) in
1815: ALL updateable column values, if column nullification is not allowed then the 2 DECODE should be replaced by a single NVL*/
1816: IF p_rule = 'R' THEN
1817: UPDATE igs_ad_apl_int api
1818: SET
1819: status = '1'
1820: , match_ind = '23'
1821: , admission_appl_number = api.update_adm_appl_number

Line 1847: FROM igs_ad_apl_int

1843:
1844: UPDATE igs_ad_ps_appl_inst_int a
1845: SET (person_id, admission_appl_number,interface_run_id ) =
1846: ( SELECT person_id, admission_appl_number ,interface_run_id
1847: FROM igs_ad_apl_int
1848: WHERE interface_appl_id = a.interface_appl_id
1849: AND status IN ('1','4') )
1850: WHERE status = '2'
1851: AND interface_appl_id IN (SELECT interface_appl_id

Line 1852: FROM igs_ad_apl_int

1848: WHERE interface_appl_id = a.interface_appl_id
1849: AND status IN ('1','4') )
1850: WHERE status = '2'
1851: AND interface_appl_id IN (SELECT interface_appl_id
1852: FROM igs_ad_apl_int
1853: WHERE interface_run_id = p_interface_run_id
1854: AND update_adm_appl_number IS NOT NULL
1855: AND status IN ('1','4'));
1856:

Line 1864: UPDATE igs_ad_apl_int api

1860: Process_application_instance(p_interface_run_id);
1861: --Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and
1862: --MATCH IND <> 21, 25, ones failed above discrepancy check
1863: IF p_rule = 'R' THEN
1864: UPDATE igs_ad_apl_int api
1865: SET
1866: status = '3'
1867: , match_ind = '20'
1868: WHERE interface_run_id = p_interface_run_id

Line 1878: UPDATE igs_ad_apl_int api

1874:
1875:
1876: --Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
1877: IF p_rule = 'R' THEN
1878: UPDATE igs_ad_apl_int api
1879: SET
1880: status = '3'
1881: , error_code = 'E700'
1882: WHERE interface_run_id = p_interface_run_id