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_PARTY_BO_PVT dependencies on HZ_PARTIES

Line 16: -- PROCEDURE set_hz_parties_bo_ver

12: p_party_id IN NUMBER,
13: p_bo_code IN VARCHAR2,
14: p_create_or_update IN VARCHAR2);
15:
16: -- PROCEDURE set_hz_parties_bo_ver
17: --
18: -- DESCRIPTION
19: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure
20: -- will be called from Organization, Organization Customer,

Line 19: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure

15:
16: -- PROCEDURE set_hz_parties_bo_ver
17: --
18: -- DESCRIPTION
19: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure
20: -- will be called from Organization, Organization Customer,
21: -- Person, Person Customer BO create API.
22: --
23: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 35: PROCEDURE set_hz_parties_bo_ver(

31: --
32: -- 04-OCT-2005 Arnold Ng Created.
33: --
34:
35: PROCEDURE set_hz_parties_bo_ver(
36: p_party_id IN NUMBER,
37: p_bo_code IN VARCHAR2
38: );
39:

Line 313: px_relationship_rec.subject_table_name:= 'HZ_PARTIES';

309: BEGIN
310: px_relationship_rec.relationship_id := p_relationship_obj.relationship_id;
311: px_relationship_rec.subject_id := p_subject_id;
312: px_relationship_rec.subject_type := p_subject_type;
313: px_relationship_rec.subject_table_name:= 'HZ_PARTIES';
314: px_relationship_rec.object_id := p_object_id;
315: px_relationship_rec.object_type := p_object_type;
316: px_relationship_rec.object_table_name := 'HZ_PARTIES';
317: px_relationship_rec.relationship_code := p_relationship_obj.relationship_code;

Line 316: px_relationship_rec.object_table_name := 'HZ_PARTIES';

312: px_relationship_rec.subject_type := p_subject_type;
313: px_relationship_rec.subject_table_name:= 'HZ_PARTIES';
314: px_relationship_rec.object_id := p_object_id;
315: px_relationship_rec.object_type := p_object_type;
316: px_relationship_rec.object_table_name := 'HZ_PARTIES';
317: px_relationship_rec.relationship_code := p_relationship_obj.relationship_code;
318: px_relationship_rec.relationship_type := p_relationship_obj.relationship_type;
319: px_relationship_rec.comments := p_relationship_obj.comments;
320: px_relationship_rec.start_date := p_relationship_obj.start_date;

Line 675: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

671: /*
672: CURSOR get_rel_party_ovn(l_subject_id NUMBER, l_object_id NUMBER,
673: l_relationship_type VARCHAR2, l_relationship_code VARCHAR2) IS
674: SELECT p.object_version_number
675: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
676: WHERE rel.subject_id = l_subject_id
677: AND rel.object_id = l_object_id
678: AND rel.relationship_type = l_relationship_type
679: AND rel.relationship_code = l_relationship_code

Line 1076: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

1072: l_object_id NUMBER;
1073:
1074: CURSOR get_rel_by_id(l_rel_id NUMBER) IS
1075: SELECT relationship_id, nvl(rel.object_version_number,1), nvl(p.object_version_number,1)
1076: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1077: WHERE rel.relationship_id = l_rel_id
1078: AND rel.party_id = p.party_id
1079: AND rel.status in ('A','I')
1080: AND rownum = 1;

Line 1261: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p

1257: l_created_by_module VARCHAR2(30);
1258:
1259: CURSOR get_rel_by_id(l_rel_id NUMBER) IS
1260: SELECT relationship_id, nvl(rel.object_version_number,1), nvl(p.object_version_number,1)
1261: FROM HZ_RELATIONSHIPS rel, HZ_PARTIES p
1262: WHERE rel.relationship_id = l_rel_id
1263: AND rel.party_id = p.party_id
1264: AND rel.status in ('A','I')
1265: AND rownum = 1;

Line 1556: AND OWNER_TABLE_NAME = 'HZ_PARTIES'

1552: ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15,
1553: ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20)
1554: FROM HZ_ORIG_SYS_REFERENCES OSR
1555: WHERE OSR.OWNER_TABLE_ID = REL.SUBJECT_ID
1556: AND OWNER_TABLE_NAME = 'HZ_PARTIES'
1557: AND STATUS = 'A') AS HZ_ORIG_SYS_REF_OBJ_TBL))
1558: FROM HZ_RELATIONSHIPS REL
1559: WHERE RELATIONSHIP_ID = l_relationship_id
1560: AND DIRECTIONAL_FLAG = 'F';

Line 3466: AND child_entity_name = 'HZ_PARTIES'

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')
3469: --AND nvl(parent_id, -99) = nvl(p_parent_id, -99)
3470: --AND nvl(parent_bo_code, 'X') = nvl(p_pbo_code, 'X')

Line 3565: set_hz_parties_bo_ver(

3561: log('Done raising event');
3562:
3563: IF(p_create_or_update = 'C') THEN
3564: log('Set BO version number');
3565: set_hz_parties_bo_ver(
3566: p_party_id => p_party_id,
3567: p_bo_code => p_bo_code
3568: );
3569: END IF;

Line 3582: -- PROCEDURE set_hz_parties_bo_ver

3578: l_paramlist.DELETE;
3579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3580: END call_bes;
3581:
3582: -- PROCEDURE set_hz_parties_bo_ver
3583: --
3584: -- DESCRIPTION
3585: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure
3586: -- will be called from Organization, Organization Customer,

Line 3585: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure

3581:
3582: -- PROCEDURE set_hz_parties_bo_ver
3583: --
3584: -- DESCRIPTION
3585: -- Set BO_VERSION_NUMBER in HZ_PARTIES table. This procedure
3586: -- will be called from Organization, Organization Customer,
3587: -- Person, Person Customer BO create API.
3588: --
3589: -- EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 3601: PROCEDURE set_hz_parties_bo_ver(

3597: --
3598: -- 04-OCT-2005 Arnold Ng Created.
3599: --
3600:
3601: PROCEDURE set_hz_parties_bo_ver(
3602: p_party_id IN NUMBER,
3603: p_bo_code IN VARCHAR2
3604: ) IS
3605: BEGIN

Line 3607: UPDATE HZ_PARTIES

3603: p_bo_code IN VARCHAR2
3604: ) IS
3605: BEGIN
3606: IF(p_bo_code = 'PERSON') THEN
3607: UPDATE HZ_PARTIES
3608: SET PERSON_BO_VERSION = (SELECT BO_VERSION_NUMBER
3609: FROM HZ_BUS_OBJ_DEFINITIONS
3610: WHERE BUSINESS_OBJECT_CODE = 'PERSON'
3611: AND ENTITY_NAME = 'HZ_PARTIES')

Line 3611: AND ENTITY_NAME = 'HZ_PARTIES')

3607: UPDATE HZ_PARTIES
3608: SET PERSON_BO_VERSION = (SELECT BO_VERSION_NUMBER
3609: FROM HZ_BUS_OBJ_DEFINITIONS
3610: WHERE BUSINESS_OBJECT_CODE = 'PERSON'
3611: AND ENTITY_NAME = 'HZ_PARTIES')
3612: WHERE PARTY_ID = p_party_id;
3613: ELSIF(p_bo_code = 'PERSON_CUST') THEN
3614: UPDATE HZ_PARTIES
3615: SET PERSON_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER

Line 3614: UPDATE HZ_PARTIES

3610: WHERE BUSINESS_OBJECT_CODE = 'PERSON'
3611: AND ENTITY_NAME = 'HZ_PARTIES')
3612: WHERE PARTY_ID = p_party_id;
3613: ELSIF(p_bo_code = 'PERSON_CUST') THEN
3614: UPDATE HZ_PARTIES
3615: SET PERSON_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3616: FROM HZ_BUS_OBJ_DEFINITIONS
3617: WHERE BUSINESS_OBJECT_CODE = 'PERSON_CUST'
3618: AND ENTITY_NAME = 'HZ_PARTIES'

Line 3618: AND ENTITY_NAME = 'HZ_PARTIES'

3614: UPDATE HZ_PARTIES
3615: SET PERSON_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3616: FROM HZ_BUS_OBJ_DEFINITIONS
3617: WHERE BUSINESS_OBJECT_CODE = 'PERSON_CUST'
3618: AND ENTITY_NAME = 'HZ_PARTIES'
3619: AND CHILD_BO_CODE IS NULL)
3620: WHERE PARTY_ID = p_party_id;
3621: ELSIF(p_bo_code = 'ORG') THEN
3622: UPDATE HZ_PARTIES

Line 3622: UPDATE HZ_PARTIES

3618: AND ENTITY_NAME = 'HZ_PARTIES'
3619: AND CHILD_BO_CODE IS NULL)
3620: WHERE PARTY_ID = p_party_id;
3621: ELSIF(p_bo_code = 'ORG') THEN
3622: UPDATE HZ_PARTIES
3623: SET ORG_BO_VERSION = (SELECT BO_VERSION_NUMBER
3624: FROM HZ_BUS_OBJ_DEFINITIONS
3625: WHERE BUSINESS_OBJECT_CODE = 'ORG'
3626: AND ENTITY_NAME = 'HZ_PARTIES')

Line 3626: AND ENTITY_NAME = 'HZ_PARTIES')

3622: UPDATE HZ_PARTIES
3623: SET ORG_BO_VERSION = (SELECT BO_VERSION_NUMBER
3624: FROM HZ_BUS_OBJ_DEFINITIONS
3625: WHERE BUSINESS_OBJECT_CODE = 'ORG'
3626: AND ENTITY_NAME = 'HZ_PARTIES')
3627: WHERE PARTY_ID = p_party_id;
3628: ELSIF(p_bo_code = 'ORG_CUST') THEN
3629: UPDATE HZ_PARTIES
3630: SET ORG_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER

Line 3629: UPDATE HZ_PARTIES

3625: WHERE BUSINESS_OBJECT_CODE = 'ORG'
3626: AND ENTITY_NAME = 'HZ_PARTIES')
3627: WHERE PARTY_ID = p_party_id;
3628: ELSIF(p_bo_code = 'ORG_CUST') THEN
3629: UPDATE HZ_PARTIES
3630: SET ORG_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3631: FROM HZ_BUS_OBJ_DEFINITIONS
3632: WHERE BUSINESS_OBJECT_CODE = 'ORG_CUST'
3633: AND ENTITY_NAME = 'HZ_PARTIES'

Line 3633: AND ENTITY_NAME = 'HZ_PARTIES'

3629: UPDATE HZ_PARTIES
3630: SET ORG_CUST_BO_VERSION = (SELECT BO_VERSION_NUMBER
3631: FROM HZ_BUS_OBJ_DEFINITIONS
3632: WHERE BUSINESS_OBJECT_CODE = 'ORG_CUST'
3633: AND ENTITY_NAME = 'HZ_PARTIES'
3634: AND CHILD_BO_CODE IS NULL)
3635: WHERE PARTY_ID = p_party_id;
3636: END IF;
3637: EXCEPTION

Line 3640: END set_hz_parties_bo_ver;

3636: END IF;
3637: EXCEPTION
3638: WHEN NO_DATA_FOUND THEN
3639: NULL;
3640: END set_hz_parties_bo_ver;
3641:
3642: -- FUNCTION is_raising_create_event
3643: --
3644: -- DESCRIPTION

Line 3679: FROM HZ_PARTIES

3675: ) RETURN BOOLEAN IS
3676: CURSOR get_party_bo_version IS
3677: SELECT nvl(PERSON_BO_VERSION, 0), nvl(PERSON_CUST_BO_VERSION, 0),
3678: nvl(ORG_BO_VERSION, 0), nvl(ORG_CUST_BO_VERSION, 0)
3679: FROM HZ_PARTIES
3680: WHERE party_id = p_party_id;
3681:
3682: CURSOR get_def_bo_version IS
3683: SELECT nvl(BO_VERSION_NUMBER, 0)

Line 3686: AND ENTITY_NAME = 'HZ_PARTIES'

3682: CURSOR get_def_bo_version IS
3683: SELECT nvl(BO_VERSION_NUMBER, 0)
3684: FROM HZ_BUS_OBJ_DEFINITIONS
3685: WHERE BUSINESS_OBJECT_CODE = p_bo_code
3686: AND ENTITY_NAME = 'HZ_PARTIES'
3687: AND CHILD_BO_CODE IS NULL;
3688:
3689: l_per_bo_ver NUMBER;
3690: l_pc_bo_ver NUMBER;

Line 3777: AND CHILD_ENTITY_NAME = 'HZ_PARTIES'

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
3780: AND PARENT_ID IS NULL
3781: AND PARENT_BO_CODE IS NULL

Line 3797: 'Y', l_insert_or_update, p_party_id, 'HZ_PARTIES', p_bo_code,

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,
3798: l_date, l_date, NULL, NULL, NULL);
3799: END;
3800:
3801: l_child_rec_exists_no := 0;

Line 3808: AND CHILD_ENTITY_NAME = 'HZ_PARTIES'

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
3811: AND PARENT_ID = p_party_id
3812: AND PARENT_BO_CODE = p_bo_code

Line 3813: AND PARENT_ENTITY_NAME = 'HZ_PARTIES'

3809: AND CHILD_BO_CODE = l_child_code
3810: AND CHILD_ID = p_party_id
3811: AND PARENT_ID = p_party_id
3812: AND PARENT_BO_CODE = p_bo_code
3813: AND PARENT_ENTITY_NAME = 'HZ_PARTIES'
3814: AND rownum = 1;
3815:
3816: IF l_child_rec_exists_no <> 0 THEN
3817: -- data already exists, no need to write

Line 3828: 'Y', l_insert_or_update, p_party_id, 'HZ_PARTIES', l_child_code,

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,
3829: l_date, l_date, 'HZ_PARTIES', p_party_id, p_bo_code);
3830: END;
3831: END add_cust_tracking;
3832:

Line 3829: l_date, l_date, 'HZ_PARTIES', p_party_id, p_bo_code);

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,
3829: l_date, l_date, 'HZ_PARTIES', p_party_id, p_bo_code);
3830: END;
3831: END add_cust_tracking;
3832:
3833: FUNCTION return_all_messages(