APPS.IGS_EN_SPLACEMENTS_API dependencies on IGS_PE_CONTACT_POINT_PKG

Line 183: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(

179: END IF;
180:
181: -- if phone number is not null but phone_id is null, new entry insert
182: IF P_PHONE IS NOT NULL AND P_PHONE_ID IS NULL THEN
183: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
184: P_ACTION => 'INSERT',
185: P_ROWID => l_rowid,
186: P_STATUS => 'A',
187: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

Line 239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated

235: END IF;
236: END IF;
237:
238:
239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated
240: IF cur_c2%FOUND AND (nvl(v_phone_update_rec.phone_number,'null')<>nvl(p_phone,'null')) THEN
241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (
242: P_ACTION =>'UPDATE',
243: P_ROWID => V_PHONE_UPDATE_REC.ROW_ID,

Line 241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (

237:
238:
239: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP with the action as updated
240: IF cur_c2%FOUND AND (nvl(v_phone_update_rec.phone_number,'null')<>nvl(p_phone,'null')) THEN
241: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP (
242: P_ACTION =>'UPDATE',
243: P_ROWID => V_PHONE_UPDATE_REC.ROW_ID,
244: P_STATUS => 'A',
245: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

Line 290: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

286:
287: -- if email address is not null but email id is null, new record - insert
288: IF P_EMAIL_ADDRESS IS NOT NULL AND P_EMAIL_ID IS NULL THEN
289:
290: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
291: P_ACTION =>'INSERT',
292: P_ROWID => l_rowid,
293: P_STATUS => 'A',
294: P_OWNER_TABLE_NAME => 'HZ_PARTIES',

Line 348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated

344: ELSE
345: l_email_address:=p_email_address;
346: END IF;
347:
348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated
349: IF cur_c3%FOUND AND (nvl(v_email_update_rec.email_address,'null')<>nvl(l_email_address,'null')) THEN
350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
351: P_ACTION => 'UPDATE',
352: P_ROWID => V_EMAIL_UPDATE_REC.ROW_ID,

Line 350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

346: END IF;
347:
348: --Call the IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE with the action as updated
349: IF cur_c3%FOUND AND (nvl(v_email_update_rec.email_address,'null')<>nvl(l_email_address,'null')) THEN
350: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
351: P_ACTION => 'UPDATE',
352: P_ROWID => V_EMAIL_UPDATE_REC.ROW_ID,
353: P_STATUS => 'A',
354: P_OWNER_TABLE_NAME => 'HZ_PARTIES',