DBA Data[Home] [Help]

APPS.HZ_POPULATE_BOT_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 3342: -- Procedure name: pop_hz_code_assignments()

3338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3339: END pop_hz_contact_points;
3340:
3341: -----------------------------------------------------------------
3342: -- Procedure name: pop_hz_code_assignments()
3343: -- Purpose: populates BOT for HZ_CODE_ASSIGNMENTS create or update
3344: -- Scope: internal
3345: -- Called From: V2 API
3346: -- Called By: HZ_CODE_ASSIGNMENTS create or update APIs

Line 3343: -- Purpose: populates BOT for HZ_CODE_ASSIGNMENTS create or update

3339: END pop_hz_contact_points;
3340:
3341: -----------------------------------------------------------------
3342: -- Procedure name: pop_hz_code_assignments()
3343: -- Purpose: populates BOT for HZ_CODE_ASSIGNMENTS create or update
3344: -- Scope: internal
3345: -- Called From: V2 API
3346: -- Called By: HZ_CODE_ASSIGNMENTS create or update APIs
3347: -- p_code_assignment_id IN NUMBER

Line 3346: -- Called By: HZ_CODE_ASSIGNMENTS create or update APIs

3342: -- Procedure name: pop_hz_code_assignments()
3343: -- Purpose: populates BOT for HZ_CODE_ASSIGNMENTS create or update
3344: -- Scope: internal
3345: -- Called From: V2 API
3346: -- Called By: HZ_CODE_ASSIGNMENTS create or update APIs
3347: -- p_code_assignment_id IN NUMBER
3348: --
3349: -- Note:
3350: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CODE_ASSIGNMENTS

Line 3350: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CODE_ASSIGNMENTS

3346: -- Called By: HZ_CODE_ASSIGNMENTS create or update APIs
3347: -- p_code_assignment_id IN NUMBER
3348: --
3349: -- Note:
3350: -- Following are the allowed PARENT and CHILD BO combinations for HZ_CODE_ASSIGNMENTS
3351: -- This procedure must ensure that the combination is valid before populating BOT
3352: --
3353: -- PARENT BO: ORG :: CHILD BO:
3354: -- PARENT BO: PERSON :: CHILD BO:

Line 3356: PROCEDURE pop_hz_code_assignments(p_operation IN VARCHAR2, p_code_assignment_id IN NUMBER) IS

3352: --
3353: -- PARENT BO: ORG :: CHILD BO:
3354: -- PARENT BO: PERSON :: CHILD BO:
3355: -----------------------------------------------------------------
3356: PROCEDURE pop_hz_code_assignments(p_operation IN VARCHAR2, p_code_assignment_id IN NUMBER) IS
3357:
3358: CURSOR C_child IS
3359: SELECT pp.LAST_UPDATE_DATE lud, pp.OWNER_TABLE_ID parent_id, pp.CODE_ASSIGNMENT_ID child_id,
3360: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code

Line 3361: FROM HZ_CODE_ASSIGNMENTS pp, HZ_PARTIES p

3357:
3358: CURSOR C_child IS
3359: SELECT pp.LAST_UPDATE_DATE lud, pp.OWNER_TABLE_ID parent_id, pp.CODE_ASSIGNMENT_ID child_id,
3360: decode(p.party_type, 'ORGANIZATION', 'ORG', 'PERSON', 'PERSON', NULL) bo_code
3361: FROM HZ_CODE_ASSIGNMENTS pp, HZ_PARTIES p
3362: WHERE pp.code_assignment_id = p_code_assignment_id
3363: AND pp.OWNER_TABLE_ID = p.party_id
3364: AND pp.OWNER_TABLE_NAME = 'HZ_PARTIES'
3365: AND p.party_type in ('ORGANIZATION', 'PERSON');

Line 3368: l_debug_prefix VARCHAR2(40) := 'pop_hz_code_assignments';

3364: AND pp.OWNER_TABLE_NAME = 'HZ_PARTIES'
3365: AND p.party_type in ('ORGANIZATION', 'PERSON');
3366:
3367: -- local variables
3368: l_debug_prefix VARCHAR2(40) := 'pop_hz_code_assignments';
3369: l_parent_id NUMBER; -- used to store parent entity identifier
3370: l_child_id NUMBER; -- used to store HZ_CODE_ASSIGNMENTS identifier
3371: l_lud DATE; -- used to store the child last update date
3372: l_bo_code VARCHAR2(30);

Line 3370: l_child_id NUMBER; -- used to store HZ_CODE_ASSIGNMENTS identifier

3366:
3367: -- local variables
3368: l_debug_prefix VARCHAR2(40) := 'pop_hz_code_assignments';
3369: l_parent_id NUMBER; -- used to store parent entity identifier
3370: l_child_id NUMBER; -- used to store HZ_CODE_ASSIGNMENTS identifier
3371: l_lud DATE; -- used to store the child last update date
3372: l_bo_code VARCHAR2(30);
3373: l_child_rec_exists_no NUMBER;
3374: l_cen VARCHAR2(30) := 'HZ_CODE_ASSIGNMENTS';

Line 3374: l_cen VARCHAR2(30) := 'HZ_CODE_ASSIGNMENTS';

3370: l_child_id NUMBER; -- used to store HZ_CODE_ASSIGNMENTS identifier
3371: l_lud DATE; -- used to store the child last update date
3372: l_bo_code VARCHAR2(30);
3373: l_child_rec_exists_no NUMBER;
3374: l_cen VARCHAR2(30) := 'HZ_CODE_ASSIGNMENTS';
3375: BEGIN
3376: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_code_assignments+',
3377: p_prefix=>l_debug_prefix,
3378: p_msg_level=>fnd_log.level_procedure);

Line 3376: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_code_assignments+',

3372: l_bo_code VARCHAR2(30);
3373: l_child_rec_exists_no NUMBER;
3374: l_cen VARCHAR2(30) := 'HZ_CODE_ASSIGNMENTS';
3375: BEGIN
3376: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_code_assignments+',
3377: p_prefix=>l_debug_prefix,
3378: p_msg_level=>fnd_log.level_procedure);
3379:
3380: -- validate p_operation

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

3380: -- validate p_operation
3381: IF p_operation IN ('I','U') THEN
3382: NULL;
3383: ELSE
3384: hz_utility_v2pub.DEBUG(p_message=> 'incorrect operation flag sent to pop_hz_code_assignments',
3385: p_prefix=>l_debug_prefix,
3386: p_msg_level=>fnd_log.level_procedure);
3387: RAISE FND_API.G_EXC_ERROR;
3388: END IF;

Line 3419: 'N', p_operation, l_child_id, 'HZ_CODE_ASSIGNMENTS', NULL,

3415: INSERT INTO HZ_BUS_OBJ_TRACKING
3416: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3417: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3418: ) VALUES (
3419: 'N', p_operation, l_child_id, 'HZ_CODE_ASSIGNMENTS', NULL,
3420: l_lud, l_lud, 'HZ_PARTIES', l_parent_id, l_bo_code);
3421:
3422: pop_parent_record(p_child_id => l_parent_id,
3423: p_lud => l_lud,

Line 3432: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_code_assignments-',

3428: p_pbo_code => NULL);
3429: END ; -- anonymous block end
3430: END LOOP;
3431:
3432: hz_utility_v2pub.DEBUG(p_message=>'pop_hz_code_assignments-',
3433: p_prefix=>l_debug_prefix,
3434: p_msg_level=>fnd_log.level_procedure);
3435: EXCEPTION
3436: WHEN OTHERS THEN

Line 3441: END pop_hz_code_assignments;

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