APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_REQUIREMENT_HEADERS_PVT

Line 161: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;

157: l_header_rec Header_Rec_Type;
158: l_line_rec Line_rec_type;
159: l_line_tbl Line_Tbl_type;
160:
161: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
162:
163: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
164: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
165: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

Line 569: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

565: WHERE task_id = l_header_rec.task_id;
566: EXCEPTION
567: WHEN NO_DATA_FOUND THEN
568: -- call private api for inserting into csp_Requirement_headers
569: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
570: P_Api_Version_Number => l_api_Version_number,
571: P_Init_Msg_List => p_init_msg_list,
572: P_Commit => FND_API.G_FALSE,
573: p_validation_level => null,

Line 601: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

597: WHERE requirement_header_id = l_header_rec.requirement_header_id;
598: EXCEPTION
599: WHEN NO_DATA_FOUND THEN
600: -- call private api for inserting into csp_Requirement_headers
601: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
602: P_Api_Version_Number => l_api_Version_number,
603: P_Init_Msg_List => p_init_msg_list,
604: P_Commit => FND_API.G_FALSE,
605: p_validation_level => null,

Line 624: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

620: END IF;
621: END;
622: ELSE
623: -- call private api for inserting into csp_Requirement_headers
624: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
625: P_Api_Version_Number => l_api_Version_number,
626: P_Init_Msg_List => p_init_msg_list,
627: P_Commit => FND_API.G_FALSE,
628: p_validation_level => null,

Line 697: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

693: END LOOP;
694:
695: ELSIF (l_header_rec.operation = 'UPDATE') THEN
696: -- call private api for updating requirement headers
697: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
698: P_Api_Version_Number => l_api_Version_number,
699: P_Init_Msg_List => p_init_msg_list,
700: P_Commit => FND_API.G_FALSE,
701: p_validation_level => null,

Line 1448: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;

1444: l_user_id NUMBER;
1445: l_login_id NUMBER;
1446: l_today DATE;
1447: l_parts_defined VARCHAR2(30);
1448: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1449: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1450: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1451: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1452: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1693: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

1689: END IF;
1690: EXCEPTION
1691: WHEN NO_DATA_FOUND THEN
1692: -- call private api for inserting into csp_Requirement_headers
1693: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1694: P_Api_Version_Number => l_api_Version_number,
1695: P_Init_Msg_List => p_init_msg_list,
1696: P_Commit => FND_API.G_FALSE,
1697: p_validation_level => null,

Line 1719: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

1715: NULL;
1716: END;
1717: ELSE */
1718: -- call private api for inserting into csp_Requirement_headers
1719: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1720: P_Api_Version_Number => l_api_Version_number,
1721: P_Init_Msg_List => p_init_msg_list,
1722: P_Commit => FND_API.G_FALSE,
1723: p_validation_level => null,

Line 1768: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

1764: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1765: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1766: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1767:
1768: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
1769: P_Api_Version_Number => l_api_Version_number,
1770: P_Init_Msg_List => p_init_msg_list,
1771: P_Commit => FND_API.G_FALSE,
1772: p_validation_level => null,