DBA Data[Home] [Help]

APPS.IGS_AD_IMP_026 dependencies on IGS_PE_WF_GEN

Line 2964: || gmaheswa 27-Jan-2006 Bug: 4938278: Call IGS_PE_WF_GEN. ADDR_BULK_SYNCHRONIZATION to raise bulk

2960: || 100 records .New variable l_processed_records added
2961: || pkpatel 22-JUN-2001 Bug no.2466466
2962: || Added the parameter p_party_site_id in update address.
2963: || Modified for performance.
2964: || gmaheswa 27-Jan-2006 Bug: 4938278: Call IGS_PE_WF_GEN. ADDR_BULK_SYNCHRONIZATION to raise bulk
2965: || address change notification after process address records of all persons.
2966: || (reverse chronological order - newest change first)
2967: */
2968:

Line 3241: --populate IGS_PE_WF_GEN.TI_ADDR_CHG_PERSONS table with party id to generate notification at the end of process

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;
3245: END prc_pe_addr;

Line 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;

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;
3245: END prc_pe_addr;
3246: