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_CERTIFICATIONS

Line 3544: -- Procedure name: pop_hz_certifications()

3540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3541: END pop_hz_citizenship;
3542:
3543: -----------------------------------------------------------------
3544: -- Procedure name: pop_hz_certifications()
3545: -- Purpose: populates BOT for HZ_CERTIFICATIONS create or update
3546: -- Scope: internal
3547: -- Called From: V2 API
3548: -- Called By: HZ_CERTIFICATIONS create or update APIs

Line 3545: -- Purpose: populates BOT for HZ_CERTIFICATIONS create or update

3541: END pop_hz_citizenship;
3542:
3543: -----------------------------------------------------------------
3544: -- Procedure name: pop_hz_certifications()
3545: -- Purpose: populates BOT for HZ_CERTIFICATIONS create or update
3546: -- Scope: internal
3547: -- Called From: V2 API
3548: -- Called By: HZ_CERTIFICATIONS create or update APIs
3549: -- Input Parameters:

Line 3548: -- Called By: HZ_CERTIFICATIONS create or update APIs

3544: -- Procedure name: pop_hz_certifications()
3545: -- Purpose: populates BOT for HZ_CERTIFICATIONS create or update
3546: -- Scope: internal
3547: -- Called From: V2 API
3548: -- Called By: HZ_CERTIFICATIONS create or update APIs
3549: -- Input Parameters:
3550: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3551: -- p_certification_id IN NUMBER
3552: --

Line 3554: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CERTIFICATIONS

3550: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3551: -- p_certification_id IN NUMBER
3552: --
3553: -- Note:
3554: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CERTIFICATIONS
3555: -- This procedure must ensure that the combination is valid before populating BOT
3556: --
3557: -- PARENT BO: ORG :: CHILD BO:
3558: -- PARENT BO: PERSON :: CHILD BO:

Line 3560: PROCEDURE pop_hz_certifications(p_operation IN VARCHAR2, p_certification_id IN NUMBER) IS

3556: --
3557: -- PARENT BO: ORG :: CHILD BO:
3558: -- PARENT BO: PERSON :: CHILD BO:
3559: -----------------------------------------------------------------
3560: PROCEDURE pop_hz_certifications(p_operation IN VARCHAR2, p_certification_id IN NUMBER) IS
3561:
3562: -- cursor statement to select the info from child table
3563: CURSOR C_child IS
3564: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CERTIFICATION_ID child_id,

Line 3566: FROM HZ_CERTIFICATIONS c, HZ_PARTIES p

3562: -- cursor statement to select the info from child table
3563: CURSOR C_child IS
3564: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CERTIFICATION_ID child_id,
3565: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3566: FROM HZ_CERTIFICATIONS c, HZ_PARTIES p
3567: WHERE c.CERTIFICATION_ID = P_CERTIFICATION_ID
3568: AND c.party_id = p.party_id
3569: AND p.party_type in ('ORGANIZATION', 'PERSON');
3570:

Line 3572: l_debug_prefix VARCHAR2(40) := 'pop_hz_certifications';

3568: AND c.party_id = p.party_id
3569: AND p.party_type in ('ORGANIZATION', 'PERSON');
3570:
3571: -- local variables
3572: l_debug_prefix VARCHAR2(40) := 'pop_hz_certifications';
3573: l_parent_id NUMBER; -- used to store parent entity identifier
3574: l_bo_code VARCHAR2(30); -- used to store BO Code
3575: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier
3576: l_lud DATE; -- used to store the child last update date

Line 3575: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier

3571: -- local variables
3572: l_debug_prefix VARCHAR2(40) := 'pop_hz_certifications';
3573: l_parent_id NUMBER; -- used to store parent entity identifier
3574: l_bo_code VARCHAR2(30); -- used to store BO Code
3575: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier
3576: l_lud DATE; -- used to store the child last update date
3577: l_child_rec_exists_no NUMBER;
3578: l_cen VARCHAR2(30) := 'HZ_CERTIFICATIONS';
3579: BEGIN

Line 3578: l_cen VARCHAR2(30) := 'HZ_CERTIFICATIONS';

3574: l_bo_code VARCHAR2(30); -- used to store BO Code
3575: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier
3576: l_lud DATE; -- used to store the child last update date
3577: l_child_rec_exists_no NUMBER;
3578: l_cen VARCHAR2(30) := 'HZ_CERTIFICATIONS';
3579: BEGIN
3580: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_certifications+',
3581: p_prefix=>l_debug_prefix,
3582: p_msg_level=>fnd_log.level_procedure);

Line 3580: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_certifications+',

3576: l_lud DATE; -- used to store the child last update date
3577: l_child_rec_exists_no NUMBER;
3578: l_cen VARCHAR2(30) := 'HZ_CERTIFICATIONS';
3579: BEGIN
3580: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_certifications+',
3581: p_prefix=>l_debug_prefix,
3582: p_msg_level=>fnd_log.level_procedure);
3583:
3584: -- validate p_operation

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

3584: -- validate p_operation
3585: IF p_operation IN ('I','U') THEN
3586: NULL;
3587: ELSE
3588: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_certifications',
3589: p_prefix=>l_debug_prefix,
3590: p_msg_level=>fnd_log.level_procedure);
3591: RAISE FND_API.G_EXC_ERROR;
3592: END IF;

Line 3622: 'N', p_operation, l_child_id, 'HZ_CERTIFICATIONS', NULL,

3618: INSERT INTO HZ_BUS_OBJ_TRACKING
3619: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3620: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3621: ) VALUES (
3622: 'N', p_operation, l_child_id, 'HZ_CERTIFICATIONS', NULL,
3623: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3624:
3625: pop_parent_record(p_child_id => l_parent_id,
3626: p_lud => l_lud,

Line 3635: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_certifications-',

3631: p_pbo_code => NULL);
3632: END ; -- anonymous block end
3633: END LOOP;
3634:
3635: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_certifications-',
3636: p_prefix=>l_debug_prefix,
3637: p_msg_level=>fnd_log.level_procedure);
3638: EXCEPTION
3639: WHEN OTHERS THEN

Line 3644: END pop_hz_certifications;

3640: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3641: p_prefix=>l_debug_prefix,
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

Line 3656: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CERTIFICATIONS

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: --
3655: -- Note:
3656: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CERTIFICATIONS
3657: -- This procedure must ensure that the combination is valid before populating BOT
3658: --
3659: -- PARENT BO: ORG :: CHILD BO:
3660: -- PARENT BO: PERSON :: CHILD BO:

Line 3932: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier

3928: -- local variables
3929: l_debug_prefix VARCHAR2(40) := 'pop_ra_cust_receipt_methods';
3930: l_parent_id NUMBER; -- used to store parent entity identifier
3931: l_bo_code VARCHAR2(30); -- used to store BO Code
3932: l_child_id NUMBER; -- used to store HZ_CERTIFICATIONS identifier
3933: l_lud DATE; -- used to store the child last update date
3934: l_child_rec_exists_no NUMBER;
3935: l_parent_bo_code VARCHAR2(30);
3936: l_parent_tbl_name VARCHAR2(30);