APPS.CSM_MULTI_MOBQRY_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 405: csp_requirement_headers rh,

401: NULL as shipment_number,
402: NULL as shipment_line_id
403: from csp_req_line_details rld,
404: csp_requirement_lines rl,
405: csp_requirement_headers rh,
406: mtl_reservations mr
407: where rld.source_type='RES'
408: and rld.requirement_line_id=rl.requirement_line_id
409: and rl.requirement_header_id=rh.requirement_header_id

Line 434: csp_requirement_headers rh ,

430: rch.shipment_num as shipment_number,
431: rcl.shipment_line_id
432: from csp_req_line_details rld,
433: csp_requirement_lines rl,
434: csp_requirement_headers rh ,
435: oe_order_lines_all oel,
436: oe_order_headers_all oeh,
437: rcv_shipment_lines rcl,
438: rcv_shipment_headers rch ,

Line 669: csp_requirement_headers rh,

665: NULL as shipment_number,
666: NULL as shipment_line_id
667: from csp_req_line_details rld,
668: csp_requirement_lines rl,
669: csp_requirement_headers rh,
670: mtl_reservations mr
671: where rld.source_type='RES'
672: and rld.requirement_line_id=rl.requirement_line_id
673: and rl.requirement_header_id=rh.requirement_header_id

Line 698: csp_requirement_headers rh ,

694: rch.shipment_num as shipment_number,
695: rcl.shipment_line_id
696: from csp_req_line_details rld,
697: csp_requirement_lines rl,
698: csp_requirement_headers rh ,
699: oe_order_lines_all oel,
700: oe_order_headers_all oeh,
701: rcv_shipment_lines rcl,
702: rcv_shipment_headers rch ,

Line 902: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;

898:
899: procedure q_upd_rqmt_ship_to( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_REQ_HDR_ID IN VARCHAR2,P_ADDRESS_TYPE IN VARCHAR2,
900: P_SHIP_LOC_SRC IN VARCHAR2,P_SHIP_LOC_ID IN VARCHAR2,p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2)
901: IS
902: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
903: l_header_rec csp_parts_requirement.Header_rec_type;
904: l_msg_count NUMBER;
905: l_msg_data VARCHAR2(2000);
906: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 929: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);

925: l_header_rec.ADDRESS_TYPE := NVL(P_ADDRESS_TYPE,'R'); --C or R or T
926:
927: SELECT TASK_ID INTO l_task_id
928: FROM JTF_TASK_ASSIGNMENTS
929: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);
930:
931: IF NVL(P_SHIP_LOC_SRC,'HR')='HZ' THEN
932: l_header_rec.SHIP_TO_LOCATION_ID:=get_hr_location(p_user_name,l_task_id,P_SHIP_LOC_ID); --party site
933: ELSE

Line 949: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

945: --l_rqmt_header_Rec.need_by_date:= nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
946:
947:
948:
949: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
950: P_Api_Version_Number => l_api_Version_number,P_Init_Msg_List => FND_API.G_TRUE,P_Commit => FND_API.G_FALSE,
951: p_validation_level => null,
952: P_REQUIREMENT_HEADER_Rec => l_rqmt_header_rec,
953: X_Return_Status => l_Return_status,

Line 1007: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);

1003: END IF;
1004:
1005: SELECT TASK_ID INTO l_task_id
1006: FROM JTF_TASK_ASSIGNMENTS
1007: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);
1008:
1009: IF NVL(P_SHIP_LOC_SRC,'HR')='HZ' THEN
1010: l_hr_loc_id:=get_hr_location(p_user_name,l_task_id,P_SHIP_LOC_ID); --party site
1011: ELSE