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_LANGUAGE

Line 552: -- Procedure name: pop_hz_person_language()

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
554: -- Scope: internal
555: -- Called From: V2 API
556: -- Called By: HZ_PERSON_LANGUAGE create or update APIs

Line 553: -- Purpose: populates BOT for HZ_PERSON_LANGUAGE create or update

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
554: -- Scope: internal
555: -- Called From: V2 API
556: -- Called By: HZ_PERSON_LANGUAGE create or update APIs
557: -- Input Parameters:

Line 556: -- Called By: HZ_PERSON_LANGUAGE create or update APIs

552: -- Procedure name: pop_hz_person_language()
553: -- Purpose: populates BOT for HZ_PERSON_LANGUAGE create or update
554: -- Scope: internal
555: -- Called From: V2 API
556: -- Called By: HZ_PERSON_LANGUAGE create or update APIs
557: -- Input Parameters:
558: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
559: -- p_LANGUAGE_USE_REFERENCE_ID IN NUMBER
560: --

Line 562: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_LANGUAGE

558: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
559: -- p_LANGUAGE_USE_REFERENCE_ID IN NUMBER
560: --
561: -- Note:
562: -- Following are the allowed PARENT and CHILD BO combinations for HZ_PERSON_LANGUAGE
563: -- This procedure must ensure that the combination is valid before populating BOT
564: --
565: -- PARENT BO: PERSON :: CHILD BO:
566: -----------------------------------------------------------------

Line 567: PROCEDURE pop_hz_person_language(p_operation IN VARCHAR2, p_language_use_reference_id IN NUMBER) IS

563: -- This procedure must ensure that the combination is valid before populating BOT
564: --
565: -- PARENT BO: PERSON :: CHILD BO:
566: -----------------------------------------------------------------
567: PROCEDURE pop_hz_person_language(p_operation IN VARCHAR2, p_language_use_reference_id IN NUMBER) IS
568:
569: -- cursor statement to select the info from child table
570: CURSOR c_child IS
571: SELECT pl.LAST_UPDATE_DATE lud, pl.PARTY_ID parent_id, pl.LANGUAGE_USE_REFERENCE_ID child_id

Line 572: FROM HZ_PERSON_LANGUAGE pl, HZ_PARTIES p

568:
569: -- cursor statement to select the info from child table
570: CURSOR c_child IS
571: SELECT pl.LAST_UPDATE_DATE lud, pl.PARTY_ID parent_id, pl.LANGUAGE_USE_REFERENCE_ID child_id
572: FROM HZ_PERSON_LANGUAGE pl, HZ_PARTIES p
573: WHERE pl.LANGUAGE_USE_REFERENCE_ID = P_LANGUAGE_USE_REFERENCE_ID
574: AND pl.party_id = p.party_id
575: AND p.party_type = 'PERSON';
576:

Line 578: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_language';

574: AND pl.party_id = p.party_id
575: AND p.party_type = 'PERSON';
576:
577: -- local variables
578: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_language';
579: l_parent_id NUMBER; -- used to store parent entity identifier
580: l_child_id NUMBER; -- used to store HZ_PERSON_LANGUAGE identifier
581: l_lud DATE; -- used to store the child last update date
582: l_child_rec_exists_no NUMBER;

Line 580: l_child_id NUMBER; -- used to store HZ_PERSON_LANGUAGE identifier

576:
577: -- local variables
578: l_debug_prefix VARCHAR2(40) := 'pop_hz_person_language';
579: l_parent_id NUMBER; -- used to store parent entity identifier
580: l_child_id NUMBER; -- used to store HZ_PERSON_LANGUAGE identifier
581: l_lud DATE; -- used to store the child last update date
582: l_child_rec_exists_no NUMBER;
583: l_cen VARCHAR2(30) := 'HZ_PERSON_LANGUAGE';
584: BEGIN

Line 583: l_cen VARCHAR2(30) := 'HZ_PERSON_LANGUAGE';

579: l_parent_id NUMBER; -- used to store parent entity identifier
580: l_child_id NUMBER; -- used to store HZ_PERSON_LANGUAGE identifier
581: l_lud DATE; -- used to store the child last update date
582: l_child_rec_exists_no NUMBER;
583: l_cen VARCHAR2(30) := 'HZ_PERSON_LANGUAGE';
584: BEGIN
585: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_language+',
586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);

Line 585: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_language+',

581: l_lud DATE; -- used to store the child last update date
582: l_child_rec_exists_no NUMBER;
583: l_cen VARCHAR2(30) := 'HZ_PERSON_LANGUAGE';
584: BEGIN
585: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_language+',
586: p_prefix=>l_debug_prefix,
587: p_msg_level=>fnd_log.level_procedure);
588:
589: -- validate p_operation

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

589: -- validate p_operation
590: IF p_operation IN ('I','U') THEN
591: NULL;
592: ELSE
593: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_person_language',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: RAISE FND_API.G_EXC_ERROR;
597: END IF;

Line 627: 'N', p_operation, l_child_id, 'HZ_PERSON_LANGUAGE', NULL,

623: INSERT INTO HZ_BUS_OBJ_TRACKING
624: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
625: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
626: ) VALUES (
627: 'N', p_operation, l_child_id, 'HZ_PERSON_LANGUAGE', NULL,
628: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
629:
630: -- populate party record
631: pop_parent_record(p_child_id => l_parent_id,

Line 641: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_language-',

637: p_pbo_code => NULL);
638: END ; -- anonymous block end
639: END LOOP;
640:
641: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_person_language-',
642: p_prefix=>l_debug_prefix,
643: p_msg_level=>fnd_log.level_procedure);
644: EXCEPTION
645: WHEN OTHERS THEN

Line 650: END pop_hz_person_language;

646: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
647: p_prefix=>l_debug_prefix,
648: p_msg_level=>fnd_log.level_procedure);
649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
650: END pop_hz_person_language;
651:
652: -----------------------------------------------------------------
653: -- Procedure name: pop_hz_person_interest()
654: -- Purpose: populates BOT for HZ_PERSON_INTEREST create or update