APPS.WSH_CREATE_CARRIERS_PKG dependencies on HZ_PARTY_USG_ASSIGNMENT_PVT

Line 45: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

41: -- Declaration for Code Assignment.
42: l_code_assignment_rec_type HZ_CLASSIFICATION_V2PUB.Code_Assignment_Rec_Type;
43:
44: -- Party Usage
45: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
46: l_party_usg_end_date DATE;
47:
48: l_sql_code number;
49: l_sqlcode number;

Line 218: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

214: l_party_usg_assignment_rec.created_by_module := 'WSH';
215: l_position := 20;
216: l_call_procedure := 'Calling assign_party_usage ';
217:
218: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
219: p_init_msg_list => FND_API.G_TRUE,
220: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW,
221: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
222: x_return_status => l_return_status,

Line 220: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW,

216: l_call_procedure := 'Calling assign_party_usage ';
217:
218: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
219: p_init_msg_list => FND_API.G_TRUE,
220: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_LOW,
221: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
222: x_return_status => l_return_status,
223: x_msg_count => l_msg_count,
224: x_msg_data => l_msg_data);

Line 511: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;

507: SELECT active, party_usg_assignment_id
508: FROM wsh_carriers_v
509: WHERE carrier_id = l_carrier_party_id;
510:
511: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
512: l_party_usg_assignment_id NUMBER;
513: -- Party Usage
514:
515: --

Line 656: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (

652: l_party_usg_assignment_rec.effective_start_date := sysdate;
653: l_party_usg_assignment_rec.effective_end_date := null;
654: l_party_usg_assignment_rec.created_by_module := 'WSH';
655:
656: HZ_PARTY_USG_ASSIGNMENT_PVT.assign_party_usage (
657: p_init_msg_list => FND_API.G_TRUE,
658: p_party_usg_assignment_rec => l_party_usg_assignment_rec,
659: x_return_status => l_return_status,
660: x_msg_count => l_msg_count,

Line 664: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (

660: x_msg_count => l_msg_count,
661: x_msg_data=> l_msg_data);
662: ELSIF(P_Carrier_info.STATUS = 'I') THEN
663:
664: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (
665: p_init_msg_list => FND_API.G_TRUE,
666: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM,
667: p_party_usg_assignment_id => l_party_usg_assignment_id,
668: p_party_id=> P_Carrier_info.CARRIER_ID,

Line 666: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM,

662: ELSIF(P_Carrier_info.STATUS = 'I') THEN
663:
664: HZ_PARTY_USG_ASSIGNMENT_PVT.inactivate_usg_assignment (
665: p_init_msg_list => FND_API.G_TRUE,
666: p_validation_level => HZ_PARTY_USG_ASSIGNMENT_PVT.G_VALID_LEVEL_MEDIUM,
667: p_party_usg_assignment_id => l_party_usg_assignment_id,
668: p_party_id=> P_Carrier_info.CARRIER_ID,
669: p_party_usage_code=> 'TRANSPORTATION_PROVIDER',
670: x_return_status => l_return_status,