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 163: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_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;
166: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
167: j NUMBER;

Line 164: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_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;
166: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
167: j NUMBER;
168:

Line 165: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

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;
166: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
167: j NUMBER;
168:
169: --Record types and tbl types for finding availability of parts

Line 655: CSP_Requirement_Lines_PVT.Create_requirement_lines(

651: l_rqmt_line_Tbl(I).requirement_header_id := l_requirement_header_id;
652: END LOOP;
653: x_rqmt_line_tbl := l_rqmt_line_tbl;
654: -- call private api for inserting into csp_requirement_lines
655: CSP_Requirement_Lines_PVT.Create_requirement_lines(
656: P_Api_Version_Number => l_api_version_number,
657: P_Init_Msg_List => p_Init_Msg_List,
658: P_Commit => FND_API.G_FALSE,
659: p_validation_level => null,

Line 714: CSP_Requirement_Lines_PVT.Update_requirement_lines(

710: END IF;
711:
712: -- call private api for updating requirement lines
713: --FOR I in 1..l_rqmt_line_tbl.COUNT LOOP
714: CSP_Requirement_Lines_PVT.Update_requirement_lines(
715: P_Api_Version_Number => l_api_version_number,
716: P_Init_Msg_List => p_Init_Msg_List,
717: P_Commit => FND_API.G_FALSE,
718: p_validation_level => null,

Line 813: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

809: l_resource_subinv VARCHAR2(30);
810: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
811: l_local_reservation_id NUMBER;
812:
813: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
814: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
815:
816: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
817: SELECT cla.organization_id,

Line 814: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

810: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
811: l_local_reservation_id NUMBER;
812:
813: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
814: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
815:
816: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
817: SELECT cla.organization_id,
818: cla.subinventory_code

Line 1057: CSP_Requirement_Lines_PVT.Update_requirement_lines(

1053: END IF;
1054:
1055: IF (l_rqmt_line_Tbl.count > 0) THEN
1056:
1057: CSP_Requirement_Lines_PVT.Update_requirement_lines(
1058: P_Api_Version_Number => l_api_version_number,
1059: P_Init_Msg_List => p_Init_Msg_List,
1060: P_Commit => p_commit,
1061: p_validation_level => null,

Line 1449: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;

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;
1453: l_msg_count NUMBER;

Line 1450: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

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;
1453: l_msg_count NUMBER;
1454: l_msg_data VARCHAR2(2000);

Line 1451: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;

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;
1453: l_msg_count NUMBER;
1454: l_msg_data VARCHAR2(2000);
1455: l_requirement_header_id NUMBER;

Line 1843: CSP_Requirement_Lines_PVT.Create_requirement_lines(

1839:
1840: l_rqmt_line_tbl(I) := l_rqmt_line_rec;
1841: END LOOP;
1842:
1843: CSP_Requirement_Lines_PVT.Create_requirement_lines(
1844: P_Api_Version_Number => l_api_version_number,
1845: P_Init_Msg_List => p_Init_Msg_List,
1846: P_Commit => FND_API.G_FALSE,
1847: p_validation_level => null,

Line 2011: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2007: l_count NUMBER;
2008: l_header_rec csp_parts_requirement.Header_rec_type;
2009: l_line_rec csp_parts_requirement.line_rec_type;
2010: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2011: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2012: EXCP_USER_DEFINED EXCEPTION;
2013: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
2014: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
2015: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

Line 2184: CSP_Requirement_Lines_PVT.Update_requirement_lines(

2180: l_rqmt_line_tbl(I).ordered_quantity := nvl(l_line_Tbl(I).ordered_quantity, 0);
2181: END LOOP;
2182:
2183: IF l_rqmt_line_tbl.COUNT > 0 THEN
2184: CSP_Requirement_Lines_PVT.Update_requirement_lines(
2185: P_Api_Version_Number => l_api_version_number,
2186: P_Init_Msg_List => p_Init_Msg_List,
2187: P_Commit => FND_API.G_FALSE,
2188: p_validation_level => null,

Line 2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2265: EXCP_USER_DEFINED EXCEPTION;
2266: I NUMBER;
2267: J NUMBER;
2268: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;