APPS.HZ_PARTY_BO_PVT dependencies on HZ_BUS_OBJ_TRACKING

Line 3459: DELETE FROM HZ_BUS_OBJ_TRACKING

3455: l_event_name VARCHAR2(240);
3456: BEGIN
3457: log('Cleanse duplicate root node');
3458: BEGIN
3459: DELETE FROM HZ_BUS_OBJ_TRACKING
3460: WHERE rowid IN
3461: ( SELECT bo_row FROM
3462: ( SELECT rowid bo_row, child_entity_name, child_id, child_bo_code, parent_entity_name, parent_id, parent_bo_code
3463: , min(rowid) over (PARTITION BY child_id, child_entity_name, child_bo_code, parent_entity_name, parent_id, parent_bo_code ORDER BY rowid RANGE UNBOUNDED PRECEDING) as min_row

Line 3464: FROM HZ_BUS_OBJ_TRACKING

3460: WHERE rowid IN
3461: ( SELECT bo_row FROM
3462: ( SELECT rowid bo_row, child_entity_name, child_id, child_bo_code, parent_entity_name, parent_id, parent_bo_code
3463: , min(rowid) over (PARTITION BY child_id, child_entity_name, child_bo_code, parent_entity_name, parent_id, parent_bo_code ORDER BY rowid RANGE UNBOUNDED PRECEDING) as min_row
3464: FROM HZ_BUS_OBJ_TRACKING
3465: WHERE child_id = p_party_id
3466: AND child_entity_name = 'HZ_PARTIES'
3467: AND nvl(child_bo_code, 'X') = nvl(p_bo_code, 'X')
3468: --AND nvl(parent_entity_name, 'X') = nvl(p_pentity_name, 'X')

Line 3775: FROM HZ_BUS_OBJ_TRACKING

3771:
3772: -- insert person_cust/org_cust record
3773: BEGIN
3774: SELECT child_id INTO l_child_rec_exists_no
3775: FROM HZ_BUS_OBJ_TRACKING
3776: WHERE event_id IS NULL
3777: AND CHILD_ENTITY_NAME = 'HZ_PARTIES'
3778: AND CHILD_BO_CODE = p_bo_code
3779: AND CHILD_ID = p_party_id

Line 3793: INSERT INTO HZ_BUS_OBJ_TRACKING

3789: p_msg_level=>fnd_log.level_procedure);
3790: END IF;
3791: EXCEPTION
3792: WHEN NO_DATA_FOUND THEN
3793: INSERT INTO HZ_BUS_OBJ_TRACKING
3794: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3795: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3796: ) VALUES (
3797: 'Y', l_insert_or_update, p_party_id, 'HZ_PARTIES', p_bo_code,

Line 3806: FROM HZ_BUS_OBJ_TRACKING

3802:
3803: -- insert person/org record with parent equals to person_cust/org_cust
3804: BEGIN
3805: SELECT child_id INTO l_child_rec_exists_no
3806: FROM HZ_BUS_OBJ_TRACKING
3807: WHERE event_id IS NULL
3808: AND CHILD_ENTITY_NAME = 'HZ_PARTIES'
3809: AND CHILD_BO_CODE = l_child_code
3810: AND CHILD_ID = p_party_id

Line 3824: INSERT INTO HZ_BUS_OBJ_TRACKING

3820: p_msg_level=>fnd_log.level_procedure);
3821: END IF;
3822: EXCEPTION
3823: WHEN NO_DATA_FOUND THEN
3824: INSERT INTO HZ_BUS_OBJ_TRACKING
3825: ( POPULATED_FLAG, CHILD_OPERATION_FLAG, CHILD_ID, CHILD_ENTITY_NAME, CHILD_BO_CODE,
3826: LAST_UPDATE_DATE, CREATION_DATE, PARENT_ENTITY_NAME, PARENT_ID, PARENT_BO_CODE
3827: ) VALUES (
3828: 'Y', l_insert_or_update, p_party_id, 'HZ_PARTIES', l_child_code,