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_PE_PERSON_SS_PKG dependencies on HZ_CONTACT_POINTS

Line 478: FROM hz_contact_points

474: attribute17,
475: attribute18,
476: attribute19,
477: attribute20
478: FROM hz_contact_points
479: WHERE contact_point_id = cp_contact_point_id;
480:
481: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
482: l_object_version_number hz_contact_points.object_version_number%TYPE;

Line 481: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

477: attribute20
478: FROM hz_contact_points
479: WHERE contact_point_id = cp_contact_point_id;
480:
481: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
482: l_object_version_number hz_contact_points.object_version_number%TYPE;
483: l_date DATE;
484: l_return_status VARCHAR2(1);
485: l_msg_count NUMBER;

Line 482: l_object_version_number hz_contact_points.object_version_number%TYPE;

478: FROM hz_contact_points
479: WHERE contact_point_id = cp_contact_point_id;
480:
481: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
482: l_object_version_number hz_contact_points.object_version_number%TYPE;
483: l_date DATE;
484: l_return_status VARCHAR2(1);
485: l_msg_count NUMBER;
486: l_msg_data VARCHAR(2000);

Line 490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,

486: l_msg_data VARCHAR(2000);
487: l_phone_number VARCHAR(2000);
488: l_mode VARCHAR2(10);
489:
490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS

Line 491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,

487: l_phone_number VARCHAR(2000);
488: l_mode VARCHAR2(10);
489:
490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS
495: SELECT contact_point_id, object_version_number

Line 492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,

488: l_mode VARCHAR2(10);
489:
490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS
495: SELECT contact_point_id, object_version_number
496: FROM hz_contact_points

Line 493: cp_status hz_contact_points.status%TYPE,

489:
490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS
495: SELECT contact_point_id, object_version_number
496: FROM hz_contact_points
497: WHERE owner_table_id = cp_person_id AND

Line 494: cp_email_address hz_contact_points.email_address%TYPE) IS

490: CURSOR dup_email_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
491: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS
495: SELECT contact_point_id, object_version_number
496: FROM hz_contact_points
497: WHERE owner_table_id = cp_person_id AND
498: contact_point_type = cp_contact_point_type AND

Line 496: FROM hz_contact_points

492: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
493: cp_status hz_contact_points.status%TYPE,
494: cp_email_address hz_contact_points.email_address%TYPE) IS
495: SELECT contact_point_id, object_version_number
496: FROM hz_contact_points
497: WHERE owner_table_id = cp_person_id AND
498: contact_point_type = cp_contact_point_type AND
499: owner_table_name = cp_owner_table_name AND
500: status = cp_status AND

Line 505: CURSOR dup_phone_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,

501: UPPER(EMAIL_ADDRESS) = UPPER(cp_email_address);
502:
503: dup_email_rec dup_email_cur%ROWTYPE;
504:
505: CURSOR dup_phone_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
506: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
508: cp_status hz_contact_points.status%TYPE,
509: cp_phone_number VARCHAR2) IS

Line 506: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,

502:
503: dup_email_rec dup_email_cur%ROWTYPE;
504:
505: CURSOR dup_phone_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
506: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
508: cp_status hz_contact_points.status%TYPE,
509: cp_phone_number VARCHAR2) IS
510: SELECT contact_point_id, object_version_number

Line 507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,

503: dup_email_rec dup_email_cur%ROWTYPE;
504:
505: CURSOR dup_phone_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
506: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
508: cp_status hz_contact_points.status%TYPE,
509: cp_phone_number VARCHAR2) IS
510: SELECT contact_point_id, object_version_number
511: FROM hz_contact_points

Line 508: cp_status hz_contact_points.status%TYPE,

504:
505: CURSOR dup_phone_cur(cp_person_id hz_contact_points.owner_table_id%TYPE,
506: cp_contact_point_type hz_contact_points.contact_point_type%TYPE,
507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
508: cp_status hz_contact_points.status%TYPE,
509: cp_phone_number VARCHAR2) IS
510: SELECT contact_point_id, object_version_number
511: FROM hz_contact_points
512: WHERE owner_table_id = cp_person_id AND

Line 511: FROM hz_contact_points

507: cp_owner_table_name hz_contact_points.owner_table_name%TYPE,
508: cp_status hz_contact_points.status%TYPE,
509: cp_phone_number VARCHAR2) IS
510: SELECT contact_point_id, object_version_number
511: FROM hz_contact_points
512: WHERE owner_table_id = cp_person_id AND
513: contact_point_type = cp_contact_point_type AND
514: owner_table_name = cp_owner_table_name AND
515: status = cp_status AND

Line 540: -- Call IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP procedure

536: FND_MSG_PUB.initialize;
537:
538: -- API body
539: -- Retrive existing information to be passed to the API.
540: -- Call IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP procedure
541: l_date := sysdate;
542: l_mode := p_mode;
543: l_contact_point_id := p_contact_point_id;
544: l_object_version_number := p_contact_point_ovn;

Line 584: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(

580: FOR c_contacs_rec IN c_contact(l_contact_point_id) LOOP
581: l_rowid := c_contacs_rec.rowid;
582: l_date := c_contacs_rec.last_update_date;
583: IF (p_email_format IS NULL) THEN -- Insert phone
584: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
585: p_action => 'UPDATE',
586: p_rowid => l_rowid,
587: p_status => p_status,
588: p_owner_table_name => 'HZ_PARTIES',

Line 624: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

620: p_attribute19 => c_contacs_rec.attribute19,
621: p_attribute20 => c_contacs_rec.attribute20
622: ) ;
623: ELSE
624: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
625: p_action => 'UPDATE',
626: p_rowid => l_rowid,
627: p_status => p_status,
628: p_owner_table_name => 'HZ_PARTIES',

Line 667: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(

663: END IF;
664: END LOOP;
665: ELSIF l_mode ='INSERT' THEN
666: IF (p_email_format IS NULL) THEN -- Insert phone
667: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKP(
668: p_action => 'INSERT',
669: p_rowid => l_rowid ,
670: p_status => p_status,
671: p_owner_table_name => 'HZ_PARTIES',

Line 686: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(

682: p_contact_point_id => l_contact_point_id,
683: p_contact_point_ovn => p_contact_point_ovn
684: ) ;
685: ELSE
686: IGS_PE_CONTACT_POINT_PKG.HZ_CONTACT_POINTS_AKE(
687: p_action => 'INSERT',
688: p_rowid => l_rowid ,
689: p_status => p_status,
690: p_owner_table_name => 'HZ_PARTIES',