eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_REQUIREMENT_LINES_PVT

Line 166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

162: l_line_tbl Line_Tbl_type;
163:
164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;

Line 167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

163:
164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;
171:

Line 168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
169: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
170: j NUMBER;
171:
172: --Record types and tbl types for finding availability of parts

Line 670: CSP_Requirement_Lines_PVT.Create_requirement_lines(

666: l_rqmt_line_Tbl(I).requirement_header_id := l_requirement_header_id;
667: END LOOP;
668: x_rqmt_line_tbl := l_rqmt_line_tbl;
669: -- call private api for inserting into csp_requirement_lines
670: CSP_Requirement_Lines_PVT.Create_requirement_lines(
671: P_Api_Version_Number => l_api_version_number,
672: P_Init_Msg_List => p_Init_Msg_List,
673: P_Commit => FND_API.G_FALSE,
674: p_validation_level => null,

Line 729: CSP_Requirement_Lines_PVT.Update_requirement_lines(

725: END IF;
726:
727: -- call private api for updating requirement lines
728: --FOR I in 1..l_rqmt_line_tbl.COUNT LOOP
729: CSP_Requirement_Lines_PVT.Update_requirement_lines(
730: P_Api_Version_Number => l_api_version_number,
731: P_Init_Msg_List => p_Init_Msg_List,
732: P_Commit => FND_API.G_FALSE,
733: p_validation_level => null,

Line 828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

824: l_resource_subinv VARCHAR2(30);
825: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
826: l_local_reservation_id NUMBER;
827:
828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
830:
831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,

Line 829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

825: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
826: l_local_reservation_id NUMBER;
827:
828: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
829: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
830:
831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,
833: cla.subinventory_code

Line 1072: CSP_Requirement_Lines_PVT.Update_requirement_lines(

1068: END IF;
1069:
1070: IF (l_rqmt_line_Tbl.count > 0) THEN
1071:
1072: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1073: P_Api_Version_Number => l_api_version_number,
1074: P_Init_Msg_List => p_Init_Msg_List,
1075: P_Commit => p_commit,
1076: p_validation_level => null,

Line 1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

1558: l_login_id NUMBER;
1559: l_today DATE;
1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;

Line 1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

1559: l_today DATE;
1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(2000);

Line 1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;

1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1566: l_msg_count NUMBER;
1567: l_msg_data VARCHAR2(2000);
1568: l_requirement_header_id NUMBER;

Line 1959: CSP_Requirement_Lines_PVT.Create_requirement_lines(

1955:
1956: l_rqmt_line_tbl(I) := l_rqmt_line_rec;
1957: END LOOP;
1958:
1959: CSP_Requirement_Lines_PVT.Create_requirement_lines(
1960: P_Api_Version_Number => l_api_version_number,
1961: P_Init_Msg_List => p_Init_Msg_List,
1962: P_Commit => FND_API.G_FALSE,
1963: p_validation_level => null,

Line 2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2123: l_count NUMBER;
2124: l_header_rec csp_parts_requirement.Header_rec_type;
2125: l_line_rec csp_parts_requirement.line_rec_type;
2126: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2127: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2128: EXCP_USER_DEFINED EXCEPTION;
2129: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
2130: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
2131: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

Line 2304: CSP_Requirement_Lines_PVT.Update_requirement_lines(

2300: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2301: END LOOP;
2302:
2303: IF l_rqmt_line_tbl.COUNT > 0 THEN
2304: CSP_Requirement_Lines_PVT.Update_requirement_lines(
2305: P_Api_Version_Number => l_api_version_number,
2306: P_Init_Msg_List => p_Init_Msg_List,
2307: P_Commit => FND_API.G_FALSE,
2308: p_validation_level => null,

Line 2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2380: l_line_rec csp_parts_requirement.line_rec_type;
2381: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2382: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2383: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2384: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2385: EXCP_USER_DEFINED EXCEPTION;
2386: I NUMBER;
2387: J NUMBER;
2388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;