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_OR_INST_IMP_001 dependencies on HZ_PARTIES

Line 30: --mmkumar 19-JUL-2005 modified cursors c_inst_present, c_party_id to use igs_pe_hz_parties instead of using hz_parties

26: -- crosswalk institution code
27: -- 5. New procedure delete_log_int_rec written to take statistics, log and delete completed
28: -- records in the interface tables. The IGS_OR_INST_INT table will also be updated be updated with
29: -- status 4 if there are any discrepency in the child records
30: --mmkumar 19-JUL-2005 modified cursors c_inst_present, c_party_id to use igs_pe_hz_parties instead of using hz_parties
31: --gmaheswa 22-Jun-06 Bug 5189180: Modified logging logic to log warning records also.
32: -------------------------------------------------------------------------------------------
33: g_records_processed NUMBER(5) := 0;
34:

Line 357: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

353: FROM IGS_OR_CWLK_V ORCV
354: WHERE ORCV.ALT_ID_TYPE = cp_data_source AND
355: ORCV.ALT_ID_VALUE = cp_data_src_val ;
356:
357: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
358: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
359: SELECT 'Y'
360: FROM igs_pe_hz_parties
361: WHERE oss_org_unit_cd = cp_inst_code;

Line 360: FROM igs_pe_hz_parties

356:
357: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
358: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
359: SELECT 'Y'
360: FROM igs_pe_hz_parties
361: WHERE oss_org_unit_cd = cp_inst_code;
362:
363: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
364: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS

Line 363: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties

359: SELECT 'Y'
360: FROM igs_pe_hz_parties
361: WHERE oss_org_unit_cd = cp_inst_code;
362:
363: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
364: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
365: SELECT party_id
366: FROM igs_pe_hz_parties
367: WHERE oss_org_unit_cd = cp_inst_code;

Line 366: FROM igs_pe_hz_parties

362:
363: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
364: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
365: SELECT party_id
366: FROM igs_pe_hz_parties
367: WHERE oss_org_unit_cd = cp_inst_code;
368:
369: -- kumma, 2446067
370: -- Created the following cursor to check whether the code already exists in the cross walk master

Line 381: l_party_id hz_parties.party_id%TYPE;

377: l_Instcount NUMBER;
378: l_Newinstcd igs_or_institution.institution_cd%TYPE;
379: l_Errind VARCHAR2(1);
380: l_Crswlkid igs_or_cwlk.crosswalk_id%TYPE;
381: l_party_id hz_parties.party_id%TYPE;
382: l_cwlkinst_rec c_inst_code%ROWTYPE;
383: l_val_err igs_or_inst_int.error_code%TYPE;
384: l_error_code igs_or_inst_int.error_code%TYPE := null; --ssawhney initialised
385: l_error_text igs_or_inst_int.error_text%TYPE := null; --ssawhney initialised

Line 1035: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

1031: FROM IGS_OR_CWLK_V ORCV
1032: WHERE ORCV.ALT_ID_TYPE = p_data_source AND
1033: ORCV.ALT_ID_VALUE = p_data_src_val ;
1034:
1035: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
1036: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
1037: SELECT 'Y'
1038: FROM igs_pe_hz_parties
1039: WHERE oss_org_unit_cd = cp_inst_code;

Line 1038: FROM igs_pe_hz_parties

1034:
1035: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
1036: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
1037: SELECT 'Y'
1038: FROM igs_pe_hz_parties
1039: WHERE oss_org_unit_cd = cp_inst_code;
1040:
1041: CURSOR c_cwlk_id(cp_inst_cd VARCHAR2 ) IS
1042: SELECT crosswalk_id

Line 1046: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties

1042: SELECT crosswalk_id
1043: FROM IGS_OR_CWLK
1044: WHERE institution_code = cp_inst_cd;
1045:
1046: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
1047: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
1048: SELECT party_id
1049: FROM igs_pe_hz_parties
1050: WHERE oss_org_unit_cd = cp_inst_code;

Line 1049: FROM igs_pe_hz_parties

1045:
1046: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
1047: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
1048: SELECT party_id
1049: FROM igs_pe_hz_parties
1050: WHERE oss_org_unit_cd = cp_inst_code;
1051:
1052: -- kumma, 2446067
1053: -- Created the following cursor to check whether the code already exists in the cross walk master

Line 1065: l_party_id hz_parties.party_id%TYPE;

1061: l_Instcount NUMBER;
1062: l_Cwlkid igs_or_cwlk.crosswalk_id%TYPE;
1063: l_Newinstcd igs_or_institution.institution_cd%TYPE;
1064: l_Errind VARCHAR2(1);
1065: l_party_id hz_parties.party_id%TYPE;
1066: l_cwlkinst_rec c_inst_code%ROWTYPE;
1067: l_val_err igs_or_inst_int.error_code%TYPE;
1068: l_error_code igs_or_inst_int.error_code%TYPE := null; --ssawhney initialised
1069: l_error_text igs_or_inst_int.error_text%TYPE := null; --ssawhney initialised

Line 1543: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties

1539: FROM IGS_OR_CWLK_V ORCV
1540: WHERE ORCV.ALT_ID_TYPE = cp_data_source AND
1541: ORCV.ALT_ID_VALUE like '%' || cp_data_src_val;
1542:
1543: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
1544: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
1545: SELECT 'Y'
1546: FROM igs_pe_hz_parties
1547: WHERE oss_org_unit_cd = cp_inst_code;

Line 1546: FROM igs_pe_hz_parties

1542:
1543: --mmkumar, party number impact, changed the folllowing cursor to verify from igs_pe_hz_parties instead of from hz_parties
1544: CURSOR c_inst_present ( cp_inst_code VARCHAR2 ) IS
1545: SELECT 'Y'
1546: FROM igs_pe_hz_parties
1547: WHERE oss_org_unit_cd = cp_inst_code;
1548:
1549: CURSOR c_cwlk_id (cp_inst_cd VARCHAR2 ) IS
1550: SELECT crosswalk_id

Line 1554: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties

1550: SELECT crosswalk_id
1551: FROM IGS_OR_CWLK
1552: WHERE institution_code = cp_inst_cd;
1553:
1554: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
1555: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
1556: SELECT party_id
1557: FROM igs_pe_hz_parties
1558: WHERE oss_org_unit_cd = cp_inst_code;

Line 1557: FROM igs_pe_hz_parties

1553:
1554: --mmkumar, party number impact, changed the folllowing cursor to pick party_id from igs_pe_hz_parties instead of from hz_parties
1555: CURSOR c_party_id ( cp_inst_code VARCHAR2 ) IS
1556: SELECT party_id
1557: FROM igs_pe_hz_parties
1558: WHERE oss_org_unit_cd = cp_inst_code;
1559:
1560:
1561: -- kumma, 2446067