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 IGS_OR_CWLK

Line 262: -- IGS_OR_INST_STAT_INT,IGS_OR_CWLK_INT,IGS_OR_CWLK_DTL_INT,IGS_OR_INST_BTCH_INT';

258:
259: IF l_schema IS NOT NULL THEN
260: -- gather statistics as the new INTERFACE batch program standard.
261: -- 'IGS_OR_ADRUSGE_INT,IGS_OR_ADR_INT,IGS_OR_INST_CON_INT,IGS_OR_INST_CPHN_INT,IGS_OR_INST_INT,IGS_OR_INST_NTS_INT,IGS_OR_INST_SDTL_INT,
262: -- IGS_OR_INST_STAT_INT,IGS_OR_CWLK_INT,IGS_OR_CWLK_DTL_INT,IGS_OR_INST_BTCH_INT';
263: -- IGS.L change, added gather statistics for table IGS_OR_ADR_INT
264:
265: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADR_INT',cascade => TRUE);
266: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_ADRUSGE_INT',cascade => TRUE);

Line 273: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_INT',cascade => TRUE);

269: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_INT',cascade => TRUE);
270: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_NTS_INT',cascade => TRUE);
271: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_SDTL_INT',cascade => TRUE);
272: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_STAT_INT',cascade => TRUE);
273: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_INT',cascade => TRUE);
274: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_DTL_INT',cascade => TRUE);
275: END IF;
276:
277: --

Line 274: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_DTL_INT',cascade => TRUE);

270: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_NTS_INT',cascade => TRUE);
271: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_SDTL_INT',cascade => TRUE);
272: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_INST_STAT_INT',cascade => TRUE);
273: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_INT',cascade => TRUE);
274: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,tabname => 'IGS_OR_CWLK_DTL_INT',cascade => TRUE);
275: END IF;
276:
277: --
278: IF p_ds_match IS NULL AND p_numeric = 'N' THEN

Line 353: FROM IGS_OR_CWLK_V ORCV

349: p_inst_rec c_inst_cur%ROWTYPE;
350:
351: CURSOR c_inst_code ( cp_data_source VARCHAR2 , cp_data_src_val VARCHAR2 ) IS
352: SELECT orcv.crosswalk_id, orcv.crosswalk_dtl_id, orcv.inst_code
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

Line 373: FROM IGS_OR_CWLK

369: -- kumma, 2446067
370: -- Created the following cursor to check whether the code already exists in the cross walk master
371: CURSOR c_cwlk_master_present (cp_inst_code VARCHAR2) IS
372: SELECT institution_code, crosswalk_id
373: FROM IGS_OR_CWLK
374: WHERE institution_code = cp_inst_code;
375:
376: l_Count NUMBER;
377: l_Instcount NUMBER;

Line 380: l_Crswlkid igs_or_cwlk.crosswalk_id%TYPE;

376: l_Count NUMBER;
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

Line 1031: FROM IGS_OR_CWLK_V ORCV

1027: IO.BATCH_ID = cp_batch_id ;
1028:
1029: CURSOR c_inst_code ( p_data_source VARCHAR2 , p_data_src_val VARCHAR2 ) IS
1030: SELECT crosswalk_id, crosswalk_dtl_id, inst_code
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

Line 1043: FROM IGS_OR_CWLK

1039: WHERE oss_org_unit_cd = cp_inst_code;
1040:
1041: CURSOR c_cwlk_id(cp_inst_cd VARCHAR2 ) IS
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

Line 1056: FROM IGS_OR_CWLK

1052: -- kumma, 2446067
1053: -- Created the following cursor to check whether the code already exists in the cross walk master
1054: CURSOR c_cwlk_master_present (cp_inst_code VARCHAR2) IS
1055: SELECT institution_code, crosswalk_id
1056: FROM IGS_OR_CWLK
1057: WHERE institution_code = cp_inst_code;
1058:
1059:
1060: l_Count NUMBER;

Line 1062: l_Cwlkid igs_or_cwlk.crosswalk_id%TYPE;

1058:
1059:
1060: l_Count NUMBER;
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;

Line 1539: FROM IGS_OR_CWLK_V ORCV

1535: -- removed the to_number function from cp_data_src_val and put the like instead of =
1536: -- and added one more column ALT_ID_VALUE in the select query
1537: CURSOR c_inst_code ( cp_data_source VARCHAR2 , cp_data_src_val VARCHAR2 ) IS
1538: SELECT crosswalk_id, crosswalk_dtl_id,inst_code, ALT_ID_VALUE
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

Line 1551: FROM IGS_OR_CWLK

1547: WHERE oss_org_unit_cd = cp_inst_code;
1548:
1549: CURSOR c_cwlk_id (cp_inst_cd VARCHAR2 ) IS
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

Line 1565: FROM IGS_OR_CWLK

1561: -- kumma, 2446067
1562: -- Created the following cursor to check whether the code already exists in the cross walk master
1563: CURSOR c_cwlk_master_present (cp_inst_code VARCHAR2) IS
1564: SELECT institution_code, crosswalk_id
1565: FROM IGS_OR_CWLK
1566: WHERE institution_code = cp_inst_code;
1567:
1568: -- kumma, 2446007
1569: CURSOR c_neumeric_test (cp_data_src_val VARCHAR2) IS

Line 2618: p_cwlk_inst_code IN igs_or_cwlk_v.inst_code%TYPE,

2614:
2615: FUNCTION validate_inst_code(
2616: p_new_inst_code IN igs_or_inst_int.new_institution_cd%TYPE,
2617: p_exst_inst_code IN igs_or_inst_int.exst_institution_cd%TYPE,
2618: p_cwlk_inst_code IN igs_or_cwlk_v.inst_code%TYPE,
2619: p_interface_id IN igs_or_inst_int.interface_id%TYPE)
2620: RETURN BOOLEAN AS
2621: /*
2622: || Created By : ssaleem