APPS.IGS_AD_IMP_026 dependencies on IGS_AD_IMP_002

Line 3154: Igs_Ad_Imp_002.g_addr_process := FALSE;

3150: UPPER(NVL(hl.province,'X')) = UPPER(NVL(ai.province,'X')) );
3151: END IF;
3152:
3153: FOR addr_rec IN addr_cur(l_interface_run_id) LOOP
3154: Igs_Ad_Imp_002.g_addr_process := FALSE;
3155: -- initialize the columns of l_addr_rec
3156: addr_rec.country := UPPER(addr_rec.country);
3157:
3158: l_addr_rec1.org_id := addr_rec.org_id;

Line 3209: Igs_Ad_Imp_002.update_address(p_addr_rec => l_addr_rec1,

3205: IF l_addr_rec.location_id IS NOT NULL THEN
3206:
3207: IF lvcAction = 'I' THEN
3208:
3209: Igs_Ad_Imp_002.update_address(p_addr_rec => l_addr_rec1,
3210: p_person_id => addr_rec.person_id,
3211: p_location_id => l_addr_rec.location_id,
3212: p_party_site_id => l_addr_rec.party_site_id );
3213: ELSIF lvcAction = 'R' THEN

Line 3217: Igs_Ad_Imp_002.update_address( p_addr_rec => l_addr_rec1,

3213: ELSIF lvcAction = 'R' THEN
3214: IF addr_rec.match_ind = '21' THEN
3215:
3216: --Make a call to IGS_AD_UPDATE_ADDRESS with the following parameters.
3217: Igs_Ad_Imp_002.update_address( p_addr_rec => l_addr_rec1,
3218: p_person_id => addr_rec.person_id,
3219: p_location_id => l_addr_rec.location_id,
3220: p_party_site_id => l_addr_rec.party_site_id);
3221: END IF;

Line 3228: Igs_Ad_Imp_002.create_address(

3224: ELSE
3225: --Make a call to IGS_AD_CREATE_ADDRESS with the following parameters.
3226:
3227: --Make a call to Create ADDRESS with the following parameters.
3228: Igs_Ad_Imp_002.create_address(
3229: p_addr_rec => l_addr_rec1,
3230: p_person_id => addr_rec.person_id,
3231: p_status => p_status ,
3232: p_error_code => p_error_code );

Line 3240: IF (Igs_Ad_Imp_002.g_addr_process) THEN

3236: IF l_processed_records = 100 THEN
3237: COMMIT;
3238: l_processed_records := 0;
3239: END IF;
3240: IF (Igs_Ad_Imp_002.g_addr_process) THEN
3241: --populate IGS_PE_WF_GEN.TI_ADDR_CHG_PERSONS table with party id to generate notification at the end of process
3242: IGS_PE_WF_GEN.TI_ADDR_CHG_PERSONS(NVL(IGS_PE_WF_GEN.TI_ADDR_CHG_PERSONS.LAST,0)+1) := addr_rec.person_id;
3243: END IF;
3244: END LOOP;