APPS.HZ_MAP_PARTY_PUB dependencies on HZ_CLASSIFICATION_V2PUB

Line 56: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,

52: x_msg_data OUT NOCOPY VARCHAR2
53: );
54:
55: procedure populate_to_classification(
56: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,
57: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
58: -- p_is_new_party IN BOOLEAN ,
59: x_return_status IN OUT NOCOPY VARCHAR2
60: ) ;

Line 2315: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;

2311: --l_fin_num_rec hz_org_info_pub.financial_numbers_rec_type;
2312: l_fin_num_rec HZ_ORGANIZATION_INFO_V2PUB.financial_number_rec_type;
2313: l_contact_points_rec hz_contact_point_v2pub.contact_point_rec_type;
2314: l_phone_rec hz_contact_point_v2pub.phone_rec_type := HZ_CONTACT_POINT_V2PUB.G_MISS_PHONE_REC;
2315: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type;
2316: l_organization_profile_id NUMBER;
2317: l_is_new_party BOOLEAN := FALSE;
2318: x_new_fin_report VARCHAR2(1);
2319:

Line 3455: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,

3451: |
3452: +===========================================================================*/
3453:
3454: procedure populate_to_classification(
3455: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,
3456: p_interface_rec IN OUT NOCOPY HZ_PARTY_INTERFACE%ROWTYPE,
3457: -- p_is_new_party IN BOOLEAN ,
3458: x_return_status IN OUT NOCOPY VARCHAR2
3459: ) IS

Line 3541: HZ_CLASSIFICATION_V2PUB.update_code_assignment (

3537: p_code_assignment_rec.application_id := NULL;
3538: p_code_assignment_rec.start_date_active := NULL;
3539: p_code_assignment_rec.end_date_active := l_end_date; -- sysdate - 1/(24*60*60); --bug4287144
3540: l_object_version_number := codes.object_version_number;
3541: HZ_CLASSIFICATION_V2PUB.update_code_assignment (
3542: p_code_assignment_rec => p_code_assignment_rec,
3543: p_object_version_number => l_object_version_number,
3544: x_return_status => x_return_status,
3545: x_msg_count => l_msg_count,

Line 3580: HZ_CLASSIFICATION_V2PUB.update_code_assignment (

3576: p_code_assignment_rec.start_date_active := NULL;
3577: --p_code_assignment_rec.end_date_active := NULL; 4287144
3578: p_code_assignment_rec.end_date_active := l_end_date; -- sysdate-1/(24*60*60);
3579:
3580: HZ_CLASSIFICATION_V2PUB.update_code_assignment (
3581: p_code_assignment_rec => p_code_assignment_rec,
3582: p_object_version_number => l_object_version_number,
3583: x_return_status => x_return_status,
3584: x_msg_count => l_msg_count,

Line 3856: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,

3852: |
3853: +===========================================================================*/
3854:
3855: procedure store_classification(
3856: p_code_assignment_rec IN OUT NOCOPY hz_classification_v2pub.code_assignment_rec_type,
3857: x_return_status IN OUT NOCOPY VARCHAR2
3858: ) IS
3859:
3860: l_msg_count NUMBER;

Line 3865: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type := p_code_assignment_rec;

3861: l_msg_data VARCHAR2(2000);
3862: l_code_assignment_id NUMBER;
3863: l_create BOOLEAN := FALSE;
3864: l_object_version_number NUMBER;
3865: l_code_assignment_rec hz_classification_v2pub.code_assignment_rec_type := p_code_assignment_rec;
3866: l_primary_flag VARCHAR2(1);
3867:
3868:
3869: BEGIN

Line 3930: HZ_CLASSIFICATION_V2PUB.update_code_assignment (

3926: l_code_assignment_rec.application_id := NULL;
3927: -- Bug 3397674 : While updating, start_date_active should not be modified. make it NULL
3928: l_code_assignment_rec.start_date_active := NULL;
3929: l_code_assignment_rec.end_date_active := sysdate;
3930: HZ_CLASSIFICATION_V2PUB.update_code_assignment (
3931: p_code_assignment_rec => l_code_assignment_rec,
3932: p_object_version_number => l_object_version_number,
3933: x_return_status => x_return_status,
3934: x_msg_count => l_msg_count,

Line 3955: HZ_CLASSIFICATION_V2PUB.create_code_assignment(

3951:
3952: p_code_assignment_rec.application_id := 222;
3953: p_code_assignment_rec.created_by_module := 'TCA_DNB_MAPPING';
3954:
3955: HZ_CLASSIFICATION_V2PUB.create_code_assignment(
3956: p_code_assignment_rec => p_code_assignment_rec,
3957: x_return_status => x_return_status,
3958: x_msg_count => l_msg_count,
3959: x_msg_data => l_msg_data,

Line 6799: l_class_code_rec HZ_CLASSIFICATION_V2PUB.class_code_rec_type;

6795: ) IS
6796:
6797: row_id varchar2(64);
6798: l_dummy VARCHAR2(1);
6799: l_class_code_rec HZ_CLASSIFICATION_V2PUB.class_code_rec_type;
6800: x_msg_count NUMBER;
6801: x_msg_data VARCHAR2(2000);
6802:
6803: -- Bug 3822690 : Modify the cursor for better performance