APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SERVICEREQUEST_PVT

Line 2479: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN

2475: -- Changes made by shijain dec 4th 2002, added the check if the profile
2476: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2477: -- hz_locations else don't need to check anything
2478:
2479: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2480: SELECT a.inventory_item_id
2481: INTO p_inventory_item_id
2482: FROM csi_item_instances a,
2483: mtl_system_items_b b,

Line 2594: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN

2590: -- Changes made by shijain dec 4th 2002, added the check if the profile
2591: -- value of cs_sr_restrict_ib is yes then check for hz_party_sites and
2592: -- hz_locations else don't need to check anything
2593:
2594: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
2595:
2596: SELECT 'x' INTO l_dummy
2597: FROM csi_item_instances a,
2598: mtl_system_items_b b,

Line 3235: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN

3231:
3232: IF ( p_customer_product_id IS NOT NULL ) AND
3233: ( p_customer_product_id <> FND_API.G_MISS_NUM ) THEN
3234:
3235: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3236:
3237: SELECT 'x' INTO l_dummy
3238: FROM csi_item_instances a,
3239: mtl_system_items_b b,

Line 3279: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN

3275: CLOSE c_ib_restrict;
3276:
3277: IF inv_item_IB_trackable = 'Y' THEN
3278:
3279: IF CS_ServiceRequest_PVT.g_restrict_ib = 'YES' THEN
3280:
3281: SELECT 'X' INTO l_dummy
3282: FROM csi_item_instances a,
3283: mtl_system_items_b b,

Line 6968: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,

6964: -- derived based onm resource id. Derivation happens in
6965: -- vldt_Sr_rec of PVT API.
6966: -- -----------------------------------------------------------------------------
6967: PROCEDURE SERVICEREQUEST_CROSS_VAL (
6968: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,
6969: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,
6970: x_cross_val_out_rec OUT NOCOPY sr_cross_val_out_rec_type,
6971: x_return_status OUT NOCOPY VARCHAR2 )
6972: IS

Line 6969: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,

6965: -- vldt_Sr_rec of PVT API.
6966: -- -----------------------------------------------------------------------------
6967: PROCEDURE SERVICEREQUEST_CROSS_VAL (
6968: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,
6969: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,
6970: x_cross_val_out_rec OUT NOCOPY sr_cross_val_out_rec_type,
6971: x_return_status OUT NOCOPY VARCHAR2 )
6972: IS
6973: lx_return_status VARCHAR2(1);

Line 8751: x_audit_vals_rec OUT NOCOPY CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE) IS

8747: p_request_id IN NUMBER,
8748: x_return_status OUT NOCOPY VARCHAR2,
8749: x_msg_count OUT NOCOPY NUMBER,
8750: x_msg_data OUT NOCOPY VARCHAR2,
8751: x_audit_vals_rec OUT NOCOPY CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE) IS
8752:
8753: CURSOR L_SERVICEREQUEST_CSR IS
8754: SELECT
8755: INCIDENT_STATUS_ID INCIDENT_STATUS_ID ,

Line 9199: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

9195: SLA_DURATION_2 SLA_DURATION_2
9196: FROM cs_incidents_all_b
9197: WHERE incident_id = p_request_id;
9198:
9199: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
9200: l_api_name CONSTANT VARCHAR2(30) := 'Prepare_Audit_Record';
9201: l_api_version CONSTANT NUMBER := 1.0;
9202:
9203: BEGIN

Line 9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND

9633: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9634: RAISE FND_API.G_EXC_ERROR;
9635: END IF;
9636: --
9637: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9638: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9639: THEN
9640: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9641: FND_MESSAGE.set_token('LOC',l_loc_type);