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.HZ_POPULATE_BOT_PKG dependencies on HZ_PERSON_PROFILES

Line 451: -- Procedure name: pop_hz_person_profiles()

447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END pop_hz_relationships;
449:
450: -----------------------------------------------------------------
451: -- Procedure name: pop_hz_person_profiles()
452: -- Purpose: populates BOT for HZ_PERSON_PROFILES create or update
453: -- Scope: internal
454: -- Called From: V2 API
455: -- Called By: HZ_PERSON_PROFILES create or update APIs

Line 452: -- Purpose: populates BOT for HZ_PERSON_PROFILES create or update

448: END pop_hz_relationships;
449:
450: -----------------------------------------------------------------
451: -- Procedure name: pop_hz_person_profiles()
452: -- Purpose: populates BOT for HZ_PERSON_PROFILES create or update
453: -- Scope: internal
454: -- Called From: V2 API
455: -- Called By: HZ_PERSON_PROFILES create or update APIs
456: -- Input Parameters:

Line 455: -- Called By: HZ_PERSON_PROFILES create or update APIs

451: -- Procedure name: pop_hz_person_profiles()
452: -- Purpose: populates BOT for HZ_PERSON_PROFILES create or update
453: -- Scope: internal
454: -- Called From: V2 API
455: -- Called By: HZ_PERSON_PROFILES create or update APIs
456: -- Input Parameters:
457: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
458: -- p_person_profile_id IN NUMBER
459: --

Line 461: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_PROFILES

457: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
458: -- p_person_profile_id IN NUMBER
459: --
460: -- Note:
461: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_PROFILES
462: -- This procedure must ensure that the combination is valid before populating BOT
463: --
464: -- PARENT BO: PERSON :: CHILD BO:
465: -- PARENT BO: PERSON_CONTACT :: CHILD BO:

Line 467: PROCEDURE pop_hz_person_profiles(p_operation IN VARCHAR2, p_person_profile_id IN NUMBER) IS

463: --
464: -- PARENT BO: PERSON :: CHILD BO:
465: -- PARENT BO: PERSON_CONTACT :: CHILD BO:
466: -----------------------------------------------------------------
467: PROCEDURE pop_hz_person_profiles(p_operation IN VARCHAR2, p_person_profile_id IN NUMBER) IS
468:
469: -- cursor statement to select the info from child table
470: CURSOR c_child IS
471: SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, PERSON_PROFILE_ID child_id

Line 472: FROM HZ_PERSON_PROFILES

468:
469: -- cursor statement to select the info from child table
470: CURSOR c_child IS
471: SELECT LAST_UPDATE_DATE lud, PARTY_ID parent_id, PERSON_PROFILE_ID child_id
472: FROM HZ_PERSON_PROFILES
473: WHERE PERSON_PROFILE_ID = P_PERSON_PROFILE_ID;
474:
475: -- local variables
476: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_profiles';

Line 476: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_profiles';

472: FROM HZ_PERSON_PROFILES
473: WHERE PERSON_PROFILE_ID = P_PERSON_PROFILE_ID;
474:
475: -- local variables
476: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_profiles';
477: l_parent_id NUMBER; -- used to store parent entity identifier
478: l_child_id NUMBER; -- used to store HZ_PERSON_PROFILES identifier
479: l_lud DATE; -- used to store the child last update date
480: l_child_rec_exists_no NUMBER;

Line 478: l_child_id NUMBER; -- used to store HZ_PERSON_PROFILES identifier

474:
475: -- local variables
476: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_profiles';
477: l_parent_id NUMBER; -- used to store parent entity identifier
478: l_child_id NUMBER; -- used to store HZ_PERSON_PROFILES identifier
479: l_lud DATE; -- used to store the child last update date
480: l_child_rec_exists_no NUMBER;
481: l_org_contact_id NUMBER;
482: l_cen VARCHAR2(30) := 'HZ_PERSON_PROFILES';

Line 482: l_cen VARCHAR2(30) := 'HZ_PERSON_PROFILES';

478: l_child_id NUMBER; -- used to store HZ_PERSON_PROFILES identifier
479: l_lud DATE; -- used to store the child last update date
480: l_child_rec_exists_no NUMBER;
481: l_org_contact_id NUMBER;
482: l_cen VARCHAR2(30) := 'HZ_PERSON_PROFILES';
483: BEGIN
484: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_profiles+',
485: p_prefix=>l_debug_prefix,
486: p_msg_level=>fnd_log.level_procedure);

Line 484: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_profiles+',

480: l_child_rec_exists_no NUMBER;
481: l_org_contact_id NUMBER;
482: l_cen VARCHAR2(30) := 'HZ_PERSON_PROFILES';
483: BEGIN
484: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_profiles+',
485: p_prefix=>l_debug_prefix,
486: p_msg_level=>fnd_log.level_procedure);
487:
488: -- validate p_operation

Line 492: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_profiles',

488: -- validate p_operation
489: IF p_operation IN ('I','U') THEN
490: NULL;
491: ELSE
492: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_profiles',
493: p_prefix=>l_debug_prefix,
494: p_msg_level=>fnd_log.level_procedure);
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;

Line 526: 'N', p_operation, l_child_id, 'HZ_PERSON_PROFILES', NULL,

522: INSERT INTO HZ_BUS_OBJ_TRACKING
523: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
524: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
525: ) VALUES (
526: 'N', p_operation, l_child_id, 'HZ_PERSON_PROFILES', NULL,
527: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
528:
529: -- populate person party record
530: pop_parent_record(p_child_id => l_parent_id,

Line 540: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_profiles-',

536: p_pbo_code => NULL);
537: END ; -- anonymous block end
538: END LOOP;
539:
540: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_profiles-',
541: p_prefix=>l_debug_prefix,
542: p_msg_level=>fnd_log.level_procedure);
543: EXCEPTION
544: WHEN OTHERS THEN

Line 549: END pop_hz_person_profiles;

545: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END pop_hz_person_profiles;
550:
551: -----------------------------------------------------------------
552: -- Procedure name: pop_hz_person_language()
553: -- Purpose: populates BOT for HZ_PERSON_LANGUAGE create or update

Line 3781: FROM HZ_PER_PROFILES_EXT_B c, HZ_PERSON_PROFILES p

3777: AND rownum = 1;
3778:
3779: CURSOR C_child_per IS
3780: SELECT c.LAST_UPDATE_DATE lud, p.PARTY_ID parent_id, c.extension_id child_id, 'PERSON' bo_code, 'HZ_PARTIES' parent_entity
3781: FROM HZ_PER_PROFILES_EXT_B c, HZ_PERSON_PROFILES p
3782: WHERE c.EXTENSION_ID = P_EXTENSION_ID
3783: AND c.PERSON_PROFILE_ID = p.PERSON_PROFILE_ID
3784: AND rownum = 1;
3785: