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_INST_IMP_003_PKG

Line 489: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);

485: -- Call Child Process
486: OPEN c_party_id(l_cwlkinst_rec.inst_code);
487: FETCH c_party_id INTO l_party_id;
488: CLOSE c_party_id;
489: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
490: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
491: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
492: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
493: END IF;

Line 490: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

486: OPEN c_party_id(l_cwlkinst_rec.inst_code);
487: FETCH c_party_id INTO l_party_id;
488: CLOSE c_party_id;
489: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
490: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
491: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
492: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
493: END IF;
494: END IF;

Line 491: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

487: FETCH c_party_id INTO l_party_id;
488: CLOSE c_party_id;
489: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
490: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
491: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
492: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
493: END IF;
494: END IF;
495: ELSE

Line 492: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

488: CLOSE c_party_id;
489: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
490: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
491: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
492: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
493: END IF;
494: END IF;
495: ELSE
496:

Line 582: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);

578: -- Call Child Process
579: OPEN c_party_id(l_Newinstcd);
580: FETCH c_party_id INTO l_party_id;
581: CLOSE c_party_id;
582: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
583: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
584: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
585: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
586: END IF; -- STEP A

Line 583: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

579: OPEN c_party_id(l_Newinstcd);
580: FETCH c_party_id INTO l_party_id;
581: CLOSE c_party_id;
582: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
583: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
584: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
585: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
586: END IF; -- STEP A
587: END IF;

Line 584: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

580: FETCH c_party_id INTO l_party_id;
581: CLOSE c_party_id;
582: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
583: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
584: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
585: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
586: END IF; -- STEP A
587: END IF;
588: END IF;

Line 585: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

581: CLOSE c_party_id;
582: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
583: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
584: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
585: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
586: END IF; -- STEP A
587: END IF;
588: END IF;
589: ELSE

Line 719: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);

715: -- Call Child Process
716: OPEN c_party_id(v_inst_rec.exst_institution_cd);
717: FETCH c_party_id INTO l_party_id;
718: CLOSE c_party_id;
719: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
720: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
721: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
722: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
723: END IF;

Line 720: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

716: OPEN c_party_id(v_inst_rec.exst_institution_cd);
717: FETCH c_party_id INTO l_party_id;
718: CLOSE c_party_id;
719: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
720: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
721: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
722: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
723: END IF;
724: END IF;

Line 721: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

717: FETCH c_party_id INTO l_party_id;
718: CLOSE c_party_id;
719: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
720: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
721: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
722: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
723: END IF;
724: END IF;
725: END IF;

Line 722: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

718: CLOSE c_party_id;
719: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
720: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
721: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
722: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
723: END IF;
724: END IF;
725: END IF;
726: ELSE

Line 831: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);

827: OPEN c_party_id(l_Newinstcd);
828: FETCH c_party_id INTO l_party_id;
829: CLOSE c_party_id;
830:
831: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
832: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
833: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
834: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
835: END IF;

Line 832: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

828: FETCH c_party_id INTO l_party_id;
829: CLOSE c_party_id;
830:
831: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
832: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
833: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
834: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
835: END IF;
836: END IF;

Line 833: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

829: CLOSE c_party_id;
830:
831: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
832: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
833: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
834: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
835: END IF;
836: END IF;
837: END IF;

Line 834: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

830:
831: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
832: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
833: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
834: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
835: END IF;
836: END IF;
837: END IF;
838: END IF;

Line 951: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);

947: -- Child Process
948: OPEN c_party_id(v_inst_rec.exst_institution_cd);
949: FETCH c_party_id INTO l_party_id;
950: CLOSE c_party_id;
951: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
952: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
953: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
954: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
955:

Line 952: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

948: OPEN c_party_id(v_inst_rec.exst_institution_cd);
949: FETCH c_party_id INTO l_party_id;
950: CLOSE c_party_id;
951: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
952: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
953: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
954: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
955:
956: END IF;

Line 953: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

949: FETCH c_party_id INTO l_party_id;
950: CLOSE c_party_id;
951: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
952: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
953: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
954: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
955:
956: END IF;
957: END IF;

Line 954: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

950: CLOSE c_party_id;
951: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
952: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
953: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
954: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
955:
956: END IF;
957: END IF;
958: END IF;

Line 1190: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);

1186: OPEN c_party_id(l_cwlkinst_rec.inst_code);
1187: FETCH c_party_id INTO l_party_id;
1188: CLOSE c_party_id;
1189:
1190: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1191: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1192: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1193: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1194: END IF;

Line 1191: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1187: FETCH c_party_id INTO l_party_id;
1188: CLOSE c_party_id;
1189:
1190: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1191: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1192: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1193: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1194: END IF;
1195: END IF;

Line 1192: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1188: CLOSE c_party_id;
1189:
1190: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1191: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1192: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1193: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1194: END IF;
1195: END IF;
1196: END IF;

Line 1193: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1189:
1190: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1191: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1192: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1193: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1194: END IF;
1195: END IF;
1196: END IF;
1197: ELSE

Line 1287: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);

1283: OPEN c_party_id(l_Newinstcd);
1284: FETCH c_party_id INTO l_party_id;
1285: CLOSE c_party_id;
1286:
1287: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1288: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1289: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1290: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1291: END IF;

Line 1288: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1284: FETCH c_party_id INTO l_party_id;
1285: CLOSE c_party_id;
1286:
1287: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1288: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1289: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1290: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1291: END IF;
1292: END IF;

Line 1289: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1285: CLOSE c_party_id;
1286:
1287: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1288: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1289: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1290: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1291: END IF;
1292: END IF;
1293: END IF;

Line 1290: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1286:
1287: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1288: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1289: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1290: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1291: END IF;
1292: END IF;
1293: END IF;
1294: END IF;

Line 1424: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);

1420: OPEN c_party_id(v_inst_rec.exst_institution_cd);
1421: FETCH c_party_id INTO l_party_id;
1422: CLOSE c_party_id;
1423:
1424: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1425: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1426: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1427: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1428: END IF;

Line 1425: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1421: FETCH c_party_id INTO l_party_id;
1422: CLOSE c_party_id;
1423:
1424: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1425: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1426: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1427: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1428: END IF;
1429: END IF;

Line 1426: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1422: CLOSE c_party_id;
1423:
1424: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1425: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1426: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1427: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1428: END IF;
1429: END IF;
1430: END IF;

Line 1427: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1423:
1424: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1425: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1426: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1427: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1428: END IF;
1429: END IF;
1430: END IF;
1431: END IF;

Line 1755: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);

1751: -- Call the Child Process
1752: OPEN c_party_id(l_cwlkinst_rec.inst_code);
1753: FETCH c_party_id INTO l_party_id;
1754: CLOSE c_party_id;
1755: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1756: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1757: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1758: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1759: END IF;

Line 1756: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1752: OPEN c_party_id(l_cwlkinst_rec.inst_code);
1753: FETCH c_party_id INTO l_party_id;
1754: CLOSE c_party_id;
1755: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1756: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1757: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1758: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1759: END IF;
1760: END IF;

Line 1757: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1753: FETCH c_party_id INTO l_party_id;
1754: CLOSE c_party_id;
1755: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1756: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1757: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1758: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1759: END IF;
1760: END IF;
1761: END IF;

Line 1758: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1754: CLOSE c_party_id;
1755: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_cwlkinst_rec.inst_code);
1756: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1757: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1758: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1759: END IF;
1760: END IF;
1761: END IF;
1762: ELSE

Line 1849: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);

1845: -- Call the Child Process
1846: OPEN c_party_id(l_Newinstcd);
1847: FETCH c_party_id INTO l_party_id;
1848: CLOSE c_party_id;
1849: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1850: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1851: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1852: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1853: END IF;

Line 1850: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1846: OPEN c_party_id(l_Newinstcd);
1847: FETCH c_party_id INTO l_party_id;
1848: CLOSE c_party_id;
1849: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1850: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1851: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1852: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1853: END IF;
1854: END IF;

Line 1851: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1847: FETCH c_party_id INTO l_party_id;
1848: CLOSE c_party_id;
1849: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1850: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1851: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1852: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1853: END IF;
1854: END IF;
1855: END IF;

Line 1852: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1848: CLOSE c_party_id;
1849: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,l_Newinstcd);
1850: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1851: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1852: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1853: END IF;
1854: END IF;
1855: END IF;
1856: END IF;

Line 1989: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);

1985: -- Child Process
1986: OPEN c_party_id(v_inst_rec.exst_institution_cd);
1987: FETCH c_party_id INTO l_party_id;
1988: CLOSE c_party_id;
1989: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1990: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1991: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1992: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1993: END IF;

Line 1990: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);

1986: OPEN c_party_id(v_inst_rec.exst_institution_cd);
1987: FETCH c_party_id INTO l_party_id;
1988: CLOSE c_party_id;
1989: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1990: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1991: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1992: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1993: END IF;
1994: END IF;

Line 1991: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);

1987: FETCH c_party_id INTO l_party_id;
1988: CLOSE c_party_id;
1989: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1990: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1991: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1992: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1993: END IF;
1994: END IF;
1995: END IF;

Line 1992: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);

1988: CLOSE c_party_id;
1989: IGS_OR_INST_IMP_003_PKG.Process_Institution_Notes(v_inst_rec.interface_id,l_party_id,v_inst_rec.exst_institution_cd);
1990: IGS_OR_INST_IMP_003_PKG.Process_Institution_Statistics(v_inst_rec.interface_id,l_party_id);
1991: IGS_OR_INST_IMP_003_PKG.Process_Institution_Address(v_inst_rec.interface_id,p_addr_usage,l_party_id);
1992: IGS_OR_INST_IMP_003_PKG.Process_Institution_Contacts(v_inst_rec.interface_id,p_person_type,l_party_id);
1993: END IF;
1994: END IF;
1995: END IF;
1996: END IF;