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_PARTY_USG_ASSIGNMENTS

Line 3646: -- Procedure name: pop_HZ_PARTY_USG_ASSIGNMENTS()

3642: p_msg_level=>fnd_log.level_procedure);
3643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3644: END pop_hz_certifications;
3645: -----------------------------------------------------------------
3646: -- Procedure name: pop_HZ_PARTY_USG_ASSIGNMENTS()
3647: -- Purpose: populates BOT for HZ_PARTY_USG_ASSIGNMENTS create or update
3648: -- Scope: internal
3649: -- Called From: V2 API
3650: -- Called By: HZ_PARTY_USG_ASSIGNMENTS create or update APIs

Line 3647: -- Purpose: populates BOT for HZ_PARTY_USG_ASSIGNMENTS create or update

3643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3644: END pop_hz_certifications;
3645: -----------------------------------------------------------------
3646: -- Procedure name: pop_HZ_PARTY_USG_ASSIGNMENTS()
3647: -- Purpose: populates BOT for HZ_PARTY_USG_ASSIGNMENTS create or update
3648: -- Scope: internal
3649: -- Called From: V2 API
3650: -- Called By: HZ_PARTY_USG_ASSIGNMENTS create or update APIs
3651: -- Input Parameters:

Line 3650: -- Called By: HZ_PARTY_USG_ASSIGNMENTS create or update APIs

3646: -- Procedure name: pop_HZ_PARTY_USG_ASSIGNMENTS()
3647: -- Purpose: populates BOT for HZ_PARTY_USG_ASSIGNMENTS create or update
3648: -- Scope: internal
3649: -- Called From: V2 API
3650: -- Called By: HZ_PARTY_USG_ASSIGNMENTS create or update APIs
3651: -- Input Parameters:
3652: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3653: -- p_PARTY_USG_ASSIGNMENT_id IN NUMBER
3654: --

Line 3662: PROCEDURE pop_HZ_PARTY_USG_ASSIGNMENTS (

3658: --
3659: -- PARENT BO: ORG :: CHILD BO:
3660: -- PARENT BO: PERSON :: CHILD BO:
3661: -----------------------------------------------------------------
3662: PROCEDURE pop_HZ_PARTY_USG_ASSIGNMENTS (
3663: p_operation IN VARCHAR2,
3664: p_PARTY_USG_ASSIGNMENT_ID IN NUMBER) IS
3665:
3666: -- cursor statement to select the info from child table

Line 3670: FROM HZ_PARTY_USG_ASSIGNMENTS c, HZ_PARTIES p

3666: -- cursor statement to select the info from child table
3667: CURSOR C_child IS
3668: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.PARTY_USG_ASSIGNMENT_ID child_id,
3669: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3670: FROM HZ_PARTY_USG_ASSIGNMENTS c, HZ_PARTIES p
3671: WHERE c.PARTY_USG_ASSIGNMENT_ID = P_PARTY_USG_ASSIGNMENT_ID
3672: AND c.party_id = p.party_id
3673: AND p.party_type in ('ORGANIZATION', 'PERSON');
3674:

Line 3676: l_debug_prefix VARCHAR2(40) := 'pop_HZ_PARTY_USG_ASSIGNMENTS';

3672: AND c.party_id = p.party_id
3673: AND p.party_type in ('ORGANIZATION', 'PERSON');
3674:
3675: -- local variables
3676: l_debug_prefix VARCHAR2(40) := 'pop_HZ_PARTY_USG_ASSIGNMENTS';
3677: l_parent_id NUMBER; -- used to store parent entity identifier
3678: l_bo_code VARCHAR2(30); -- used to store BO Code
3679: l_child_id NUMBER; -- used to store HZ_PARTY_USG_ASSIGNMENTS identifier
3680: l_lud DATE; -- used to store the child last update date

Line 3679: l_child_id NUMBER; -- used to store HZ_PARTY_USG_ASSIGNMENTS identifier

3675: -- local variables
3676: l_debug_prefix VARCHAR2(40) := 'pop_HZ_PARTY_USG_ASSIGNMENTS';
3677: l_parent_id NUMBER; -- used to store parent entity identifier
3678: l_bo_code VARCHAR2(30); -- used to store BO Code
3679: l_child_id NUMBER; -- used to store HZ_PARTY_USG_ASSIGNMENTS identifier
3680: l_lud DATE; -- used to store the child last update date
3681: l_child_rec_exists_no NUMBER;
3682: l_cen VARCHAR2(30) := 'HZ_PARTY_USG_ASSIGNMENTS';
3683: BEGIN

Line 3682: l_cen VARCHAR2(30) := 'HZ_PARTY_USG_ASSIGNMENTS';

3678: l_bo_code VARCHAR2(30); -- used to store BO Code
3679: l_child_id NUMBER; -- used to store HZ_PARTY_USG_ASSIGNMENTS identifier
3680: l_lud DATE; -- used to store the child last update date
3681: l_child_rec_exists_no NUMBER;
3682: l_cen VARCHAR2(30) := 'HZ_PARTY_USG_ASSIGNMENTS';
3683: BEGIN
3684: hz_utility_v2pub.DEBUG(p_message=>'pop_HZ_PARTY_USG_ASSIGNMENTS+',
3685: p_prefix=>l_debug_prefix,
3686: p_msg_level=>fnd_log.level_procedure);

Line 3684: hz_utility_v2pub.DEBUG(p_message=>'pop_HZ_PARTY_USG_ASSIGNMENTS+',

3680: l_lud DATE; -- used to store the child last update date
3681: l_child_rec_exists_no NUMBER;
3682: l_cen VARCHAR2(30) := 'HZ_PARTY_USG_ASSIGNMENTS';
3683: BEGIN
3684: hz_utility_v2pub.DEBUG(p_message=>'pop_HZ_PARTY_USG_ASSIGNMENTS+',
3685: p_prefix=>l_debug_prefix,
3686: p_msg_level=>fnd_log.level_procedure);
3687:
3688: -- validate p_operation

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

3688: -- validate p_operation
3689: IF p_operation IN ('I','U') THEN
3690: NULL;
3691: ELSE
3692: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_HZ_PARTY_USG_ASSIGNMENTS',
3693: p_prefix=>l_debug_prefix,
3694: p_msg_level=>fnd_log.level_procedure);
3695: RAISE FND_API.G_EXC_ERROR;
3696: END IF;

Line 3726: 'N', p_operation, l_child_id, 'HZ_PARTY_USG_ASSIGNMENTS', NULL,

3722: INSERT INTO HZ_BUS_OBJ_TRACKING
3723: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3724: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3725: ) VALUES (
3726: 'N', p_operation, l_child_id, 'HZ_PARTY_USG_ASSIGNMENTS', NULL,
3727: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3728:
3729: pop_parent_record(p_child_id => l_parent_id,
3730: p_lud => l_lud,

Line 3739: hz_utility_v2pub.DEBUG(p_message=>'pop_HZ_PARTY_USG_ASSIGNMENTS-',

3735: p_pbo_code => NULL);
3736: END ; -- anonymous block end
3737: END LOOP;
3738:
3739: hz_utility_v2pub.DEBUG(p_message=>'pop_HZ_PARTY_USG_ASSIGNMENTS-',
3740: p_prefix=>l_debug_prefix,
3741: p_msg_level=>fnd_log.level_procedure);
3742: EXCEPTION
3743: WHEN OTHERS THEN

Line 3748: END pop_HZ_PARTY_USG_ASSIGNMENTS;

3744: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3745: p_prefix=>l_debug_prefix,
3746: p_msg_level=>fnd_log.level_procedure);
3747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3748: END pop_HZ_PARTY_USG_ASSIGNMENTS;
3749:
3750: -----------------------------------------------------------------
3751: -- Procedure name: pop_hz_extensibility()
3752: -- Purpose: populates BOT for extensibility create or update