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_CITIZENSHIP

Line 3444: -- Procedure name: pop_hz_citizenship()

3440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3441: END pop_hz_code_assignments;
3442:
3443: -----------------------------------------------------------------
3444: -- Procedure name: pop_hz_citizenship()
3445: -- Purpose: populates BOT for HZ_CITIZENSHIP create or update
3446: -- Scope: internal
3447: -- Called From: V2 API
3448: -- Called By: HZ_CITIZENSHIP create or update APIs

Line 3445: -- Purpose: populates BOT for HZ_CITIZENSHIP create or update

3441: END pop_hz_code_assignments;
3442:
3443: -----------------------------------------------------------------
3444: -- Procedure name: pop_hz_citizenship()
3445: -- Purpose: populates BOT for HZ_CITIZENSHIP create or update
3446: -- Scope: internal
3447: -- Called From: V2 API
3448: -- Called By: HZ_CITIZENSHIP create or update APIs
3449: -- Input Parameters:

Line 3448: -- Called By: HZ_CITIZENSHIP create or update APIs

3444: -- Procedure name: pop_hz_citizenship()
3445: -- Purpose: populates BOT for HZ_CITIZENSHIP create or update
3446: -- Scope: internal
3447: -- Called From: V2 API
3448: -- Called By: HZ_CITIZENSHIP create or update APIs
3449: -- Input Parameters:
3450: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3451: -- p_citizenship_id IN NUMBER
3452: --

Line 3454: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CITIZENSHIP

3450: -- p_operation -- contains I or U. 'I' if create API is calling this otherwise 'U'.
3451: -- p_citizenship_id IN NUMBER
3452: --
3453: -- Note:
3454: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CITIZENSHIP
3455: -- This procedure must ensure that the combination is valid before populating BOT
3456: --
3457: -- PARENT BO: PERSON :: CHILD BO:
3458: -----------------------------------------------------------------

Line 3459: PROCEDURE pop_hz_citizenship(p_operation IN VARCHAR2, p_citizenship_id IN NUMBER) IS

3455: -- This procedure must ensure that the combination is valid before populating BOT
3456: --
3457: -- PARENT BO: PERSON :: CHILD BO:
3458: -----------------------------------------------------------------
3459: PROCEDURE pop_hz_citizenship(p_operation IN VARCHAR2, p_citizenship_id IN NUMBER) IS
3460:
3461: -- cursor statement to select the info from child table
3462: CURSOR C_child IS
3463: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CITIZENSHIP_ID child_id

Line 3464: FROM HZ_CITIZENSHIP c, HZ_PARTIES p

3460:
3461: -- cursor statement to select the info from child table
3462: CURSOR C_child IS
3463: SELECT c.LAST_UPDATE_DATE lud, c.PARTY_ID parent_id, c.CITIZENSHIP_ID child_id
3464: FROM HZ_CITIZENSHIP c, HZ_PARTIES p
3465: WHERE c.CITIZENSHIP_ID = P_CITIZENSHIP_ID
3466: AND c.party_id = p.party_id
3467: AND p.party_type = 'PERSON';
3468:

Line 3470: l_debug_prefix VARCHAR2(40) := 'pop_hz_citizenship';

3466: AND c.party_id = p.party_id
3467: AND p.party_type = 'PERSON';
3468:
3469: -- local variables
3470: l_debug_prefix VARCHAR2(40) := 'pop_hz_citizenship';
3471: l_parent_id NUMBER; -- used to store parent entity identifier
3472: l_child_id NUMBER; -- used to store HZ_CITIZENSHIP identifier
3473: l_lud DATE; -- used to store the child last update date
3474: l_child_rec_exists_no NUMBER;

Line 3472: l_child_id NUMBER; -- used to store HZ_CITIZENSHIP identifier

3468:
3469: -- local variables
3470: l_debug_prefix VARCHAR2(40) := 'pop_hz_citizenship';
3471: l_parent_id NUMBER; -- used to store parent entity identifier
3472: l_child_id NUMBER; -- used to store HZ_CITIZENSHIP identifier
3473: l_lud DATE; -- used to store the child last update date
3474: l_child_rec_exists_no NUMBER;
3475: l_cen VARCHAR2(30) := 'HZ_CITIZENSHIP';
3476: BEGIN

Line 3475: l_cen VARCHAR2(30) := 'HZ_CITIZENSHIP';

3471: l_parent_id NUMBER; -- used to store parent entity identifier
3472: l_child_id NUMBER; -- used to store HZ_CITIZENSHIP identifier
3473: l_lud DATE; -- used to store the child last update date
3474: l_child_rec_exists_no NUMBER;
3475: l_cen VARCHAR2(30) := 'HZ_CITIZENSHIP';
3476: BEGIN
3477: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_citizenship+',
3478: p_prefix=>l_debug_prefix,
3479: p_msg_level=>fnd_log.level_procedure);

Line 3477: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_citizenship+',

3473: l_lud DATE; -- used to store the child last update date
3474: l_child_rec_exists_no NUMBER;
3475: l_cen VARCHAR2(30) := 'HZ_CITIZENSHIP';
3476: BEGIN
3477: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_citizenship+',
3478: p_prefix=>l_debug_prefix,
3479: p_msg_level=>fnd_log.level_procedure);
3480:
3481: -- validate p_operation

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

3481: -- validate p_operation
3482: IF p_operation IN ('I','U') THEN
3483: NULL;
3484: ELSE
3485: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_citizenship',
3486: p_prefix=>l_debug_prefix,
3487: p_msg_level=>fnd_log.level_procedure);
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;

Line 3519: 'N', p_operation, l_child_id, 'HZ_CITIZENSHIP', NULL,

3515: INSERT INTO HZ_BUS_OBJ_TRACKING
3516: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3517: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3518: ) VALUES (
3519: 'N', p_operation, l_child_id, 'HZ_CITIZENSHIP', NULL,
3520: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, 'PERSON');
3521:
3522: pop_parent_record(p_child_id => l_parent_id,
3523: p_lud => l_lud,

Line 3532: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_citizenship-',

3528: p_pbo_code => NULL);
3529: END ; -- anonymous block end
3530: END LOOP;
3531:
3532: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_citizenship-',
3533: p_prefix=>l_debug_prefix,
3534: p_msg_level=>fnd_log.level_procedure);
3535: EXCEPTION
3536: WHEN OTHERS THEN

Line 3541: END pop_hz_citizenship;

3537: hz_utility_v2pub.DEBUG(p_message=> SQLERRM,
3538: p_prefix=>l_debug_prefix,
3539: p_msg_level=>fnd_log.level_procedure);
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