DBA Data[Home] [Help]

APPS.HZ_PARTY_BO_PVT dependencies on STANDARD

Line 461: -- Standard start of API savepoint

457: l_obj_os VARCHAR2(30);
458: l_obj_osr VARCHAR2(255);
459: l_obj_type VARCHAR2(30);
460: BEGIN
461: -- Standard start of API savepoint
462: SAVEPOINT create_relationships_pvt;
463:
464: -- initialize API return status to success.
465: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 685: -- Standard start of API savepoint

681: AND rel.party_id = p.party_id
682: AND p.status in ('A','I');
683: */
684: BEGIN
685: -- Standard start of API savepoint
686: SAVEPOINT save_relationships_pvt;
687:
688: -- initialize API return status to success.
689: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 894: -- Standard start of API savepoint

890: l_party_number VARCHAR2(30);
891: l_created_by_module VARCHAR2(30);
892:
893: BEGIN
894: -- Standard start of API savepoint
895: SAVEPOINT create_relatobj_pvt;
896:
897: -- initialize API return status to success.
898: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1082: -- Standard start of API savepoint

1078: AND rel.party_id = p.party_id
1079: AND rel.status in ('A','I')
1080: AND rownum = 1;
1081: BEGIN
1082: -- Standard start of API savepoint
1083: SAVEPOINT update_relatobj_pvt;
1084:
1085: -- initialize API return status to success.
1086: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1267: -- Standard start of API savepoint

1263: AND rel.party_id = p.party_id
1264: AND rel.status in ('A','I')
1265: AND rownum = 1;
1266: BEGIN
1267: -- Standard start of API savepoint
1268: SAVEPOINT save_relatobj_pvt;
1269:
1270: -- initialize API return status to success.
1271: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1708: -- Standard start of API savepoint

1704: l_debug_prefix VARCHAR2(30);
1705: l_code_assign_id NUMBER;
1706: l_code_assign_rec HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE;
1707: BEGIN
1708: -- Standard start of API savepoint
1709: SAVEPOINT create_classifications_pvt;
1710:
1711: -- initialize API return status to success.
1712: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1883: -- Standard start of API savepoint

1879: l_code_assign_id NUMBER;
1880: l_code_assign_rec HZ_CLASSIFICATION_V2PUB.CODE_ASSIGNMENT_REC_TYPE;
1881: l_ovn NUMBER := NULL;
1882: BEGIN
1883: -- Standard start of API savepoint
1884: SAVEPOINT save_classifications_pvt;
1885:
1886: -- initialize API return status to success.
1887: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2093: -- Standard start of API savepoint

2089: l_debug_prefix VARCHAR2(30);
2090: l_cert_id NUMBER;
2091: l_cert_rec HZ_ORG_INFO_PUB.CERTIFICATIONS_REC_TYPE;
2092: BEGIN
2093: -- Standard start of API savepoint
2094: SAVEPOINT create_certifications_pvt;
2095:
2096: -- initialize API return status to success.
2097: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2266: -- Standard start of API savepoint

2262: l_cert_id NUMBER;
2263: l_cert_rec HZ_ORG_INFO_PUB.CERTIFICATIONS_REC_TYPE;
2264: l_lud DATE;
2265: BEGIN
2266: -- Standard start of API savepoint
2267: SAVEPOINT save_certifications_pvt;
2268:
2269: -- initialize API return status to success.
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2474: -- Standard start of API savepoint

2470: l_debug_prefix VARCHAR2(30);
2471: l_fin_prof_id NUMBER;
2472: l_fin_prof_rec HZ_PARTY_INFO_PUB.FINANCIAL_PROFILE_REC_TYPE;
2473: BEGIN
2474: -- Standard start of API savepoint
2475: SAVEPOINT create_financial_profiles_pvt;
2476:
2477: -- initialize API return status to success.
2478: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2647: -- Standard start of API savepoint

2643: l_fin_prof_id NUMBER;
2644: l_fin_prof_rec HZ_PARTY_INFO_PUB.FINANCIAL_PROFILE_REC_TYPE;
2645: l_lud DATE;
2646: BEGIN
2647: -- Standard start of API savepoint
2648: SAVEPOINT save_financial_profiles_pvt;
2649:
2650: -- initialize API return status to success.
2651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2853: -- Standard start of API savepoint

2849: ) IS
2850: l_debug_prefix VARCHAR2(30);
2851: l_ovn NUMBER := NULL;
2852: BEGIN
2853: -- Standard start of API savepoint
2854: SAVEPOINT save_party_preferences_pvt;
2855:
2856: -- initialize API return status to success.
2857: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3094: -- Standard start of API savepoint

3090: )IS
3091: l_debug_prefix VARCHAR2(30);
3092: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
3093: BEGIN
3094: -- Standard start of API savepoint
3095: SAVEPOINT create_party_usage_assgmnt_pvt;
3096:
3097: -- initialize API return status to success.
3098: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3264: -- Standard start of API savepoint

3260: l_party_usg_assignment_id NUMBER;
3261: l_party_usg_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
3262: l_lud DATE;
3263: BEGIN
3264: -- Standard start of API savepoint
3265: SAVEPOINT save_party_usage_assgmnt_pvt;
3266:
3267: -- initialize API return status to success.
3268: x_return_status := FND_API.G_RET_STS_SUCCESS;