APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_SERVICEREQUEST_PVT

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

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

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

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

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

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

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

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

Line 6952: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,

6948: -- derived based onm resource id. Derivation happens in
6949: -- vldt_Sr_rec of PVT API.
6950: -- -----------------------------------------------------------------------------
6951: PROCEDURE SERVICEREQUEST_CROSS_VAL (
6952: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,
6953: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,
6954: x_cross_val_out_rec OUT NOCOPY sr_cross_val_out_rec_type,
6955: x_return_status OUT NOCOPY VARCHAR2 )
6956: IS

Line 6953: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,

6949: -- vldt_Sr_rec of PVT API.
6950: -- -----------------------------------------------------------------------------
6951: PROCEDURE SERVICEREQUEST_CROSS_VAL (
6952: p_new_sr_rec IN cs_servicerequest_pvt.service_request_rec_type,
6953: p_old_sr_rec IN cs_servicerequest_pvt.sr_oldvalues_rec_type,
6954: x_cross_val_out_rec OUT NOCOPY sr_cross_val_out_rec_type,
6955: x_return_status OUT NOCOPY VARCHAR2 )
6956: IS
6957: lx_return_status VARCHAR2(1);

Line 8735: x_audit_vals_rec OUT NOCOPY CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE) IS

8731: p_request_id IN NUMBER,
8732: x_return_status OUT NOCOPY VARCHAR2,
8733: x_msg_count OUT NOCOPY NUMBER,
8734: x_msg_data OUT NOCOPY VARCHAR2,
8735: x_audit_vals_rec OUT NOCOPY CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE) IS
8736:
8737: CURSOR L_SERVICEREQUEST_CSR IS
8738: SELECT
8739: INCIDENT_STATUS_ID INCIDENT_STATUS_ID ,

Line 9147: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

9143: MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID
9144: FROM cs_incidents_all_b
9145: WHERE incident_id = p_request_id;
9146:
9147: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
9148: l_api_name CONSTANT VARCHAR2(30) := 'Prepare_Audit_Record';
9149: l_api_version CONSTANT NUMBER := 1.0;
9150:
9151: BEGIN

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

9581: FND_MSG_PUB.add_detail(p_associated_column1=> 'CS_INCIDENTS_ALL_B.CUSTOMER_PRODUCT_ID');
9582: RAISE FND_API.G_EXC_ERROR;
9583: END IF;
9584: --
9585: IF CS_SERVICEREQUEST_PVT.g_restrict_ib = 'YES' AND
9586: l_loc_type NOT IN ('HZ_PARTY_SITES', 'HZ_LOCATIONS')
9587: THEN
9588: FND_MESSAGE.set_name('CS','CS_SR_CP_LOCATION_INVALID'); -- Customer porduct installed location is invalid
9589: FND_MESSAGE.set_token('LOC',l_loc_type);