APPS.IGS_OR_INST_IMP_002 dependencies on IGS_OR_ORG_ALT_IDS

Line 350: Purpose : This Procedure creates a New Record in the IGS_OR_ORG_ALT_IDS table

346: AS
347: /*************************************************************
348: Created By :samaresh
349: Date Created By : 17-JUL-2001
350: Purpose : This Procedure creates a New Record in the IGS_OR_ORG_ALT_IDS table
351: Know limitations, enhancements or remarks
352: Change History
353: Who When What
354: ssawhney 30-APR-2003 V2API - OVN implementation

Line 365: CURSOR c_exists (cp_alt_id_type igs_or_org_alt_ids.org_alternate_id_type%TYPE,

361: npalanis 27-OCT-2002 Bug No: 2613704
362: Added the parameter p_error_code and added the check for overlap of alternate ID
363: ***************************************************************/
364:
365: CURSOR c_exists (cp_alt_id_type igs_or_org_alt_ids.org_alternate_id_type%TYPE,
366: cp_alt_id_val VARCHAR2,
367: cp_instcd igs_or_org_alt_ids.org_structure_id%TYPE,
368: cp_structure_type igs_or_org_alt_ids.org_structure_type%TYPE,
369: cp_end_date VARCHAR2) IS

Line 367: cp_instcd igs_or_org_alt_ids.org_structure_id%TYPE,

363: ***************************************************************/
364:
365: CURSOR c_exists (cp_alt_id_type igs_or_org_alt_ids.org_alternate_id_type%TYPE,
366: cp_alt_id_val VARCHAR2,
367: cp_instcd igs_or_org_alt_ids.org_structure_id%TYPE,
368: cp_structure_type igs_or_org_alt_ids.org_structure_type%TYPE,
369: cp_end_date VARCHAR2) IS
370: SELECT org_alternate_id
371: FROM igs_or_org_alt_ids

Line 368: cp_structure_type igs_or_org_alt_ids.org_structure_type%TYPE,

364:
365: CURSOR c_exists (cp_alt_id_type igs_or_org_alt_ids.org_alternate_id_type%TYPE,
366: cp_alt_id_val VARCHAR2,
367: cp_instcd igs_or_org_alt_ids.org_structure_id%TYPE,
368: cp_structure_type igs_or_org_alt_ids.org_structure_type%TYPE,
369: cp_end_date VARCHAR2) IS
370: SELECT org_alternate_id
371: FROM igs_or_org_alt_ids
372: WHERE org_alternate_id_type = cp_alt_id_type

Line 371: FROM igs_or_org_alt_ids

367: cp_instcd igs_or_org_alt_ids.org_structure_id%TYPE,
368: cp_structure_type igs_or_org_alt_ids.org_structure_type%TYPE,
369: cp_end_date VARCHAR2) IS
370: SELECT org_alternate_id
371: FROM igs_or_org_alt_ids
372: WHERE org_alternate_id_type = cp_alt_id_type
373: AND org_structure_id = cp_instcd
374: AND org_structure_type = cp_structure_type
375: AND ( SYSDATE BETWEEN start_date AND NVL(end_date,TO_DATE(cp_end_date,'YYYY/MM/DD')) );

Line 386: l_org_alternate_id igs_or_org_alt_ids.org_alternate_id%TYPE;

382: ihp.party_id = hp.party_id;
383:
384: l_rowid VARCHAR2(25);
385: l_partyid hz_parties.party_id%TYPE;
386: l_org_alternate_id igs_or_org_alt_ids.org_alternate_id%TYPE;
387:
388: BEGIN
389: p_error_code := NULL;
390: OPEN c_exists (p_altidtype,p_altidval,p_instcd,'INSTITUTE','4712/12/31');

Line 400: IGS_OR_ORG_ALT_IDS_PKG.INSERT_ROW(

396: OPEN c_partyid(p_instcd);
397: FETCH c_partyid INTO l_partyid;
398: CLOSE c_partyid;
399:
400: IGS_OR_ORG_ALT_IDS_PKG.INSERT_ROW(
401: x_rowid => l_rowid,
402: x_org_structure_id => p_instcd,
403: x_org_structure_type => 'INSTITUTE',
404: x_org_alternate_id_type => p_altidtype,