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

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 493: from csp_requirement_lines

489: ELSE
490: BEGIN
491: select requirement_line_id
492: into l_check_existence
493: from csp_requirement_lines
494: where requirement_line_id = l_line_rec.requirement_line_id;
495: EXCEPTION
496: WHEN NO_DATA_FOUND THEN
497: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

502: WHEN OTHERS THEN
503: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
504: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
505: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
506: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
507: FND_MSG_PUB.ADD;
508: RAISE EXCP_USER_DEFINED;
509: END;
510: END IF;

Line 654: -- call private api for inserting into csp_requirement_lines

650: FOR I in 1..l_rqmt_line_Tbl.COUNT LOOP
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,

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 907: update csp_Requirement_lines

903: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
904: RAISE FND_API.G_EXC_ERROR;
905: END If;
906:
907: update csp_Requirement_lines
908: set local_Reservation_id = l_local_Reservation_id
909: where requirement_line_id = l_line_Rec.requirement_line_id;
910:
911: END IF;

Line 955: from csp_requirement_lines

951: ELSE
952: BEGIN
953: select requirement_line_id
954: into l_check_existence
955: from csp_requirement_lines
956: where requirement_line_id = l_line_rec.requirement_line_id;
957: EXCEPTION
958: WHEN NO_DATA_FOUND THEN
959: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

963: WHEN OTHERS THEN
964: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
965: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
966: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
967: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
968: FND_MSG_PUB.ADD;
969: RAISE EXCP_USER_DEFINED;
970: END;
971: END IF;

Line 1021: from csp_requirement_lines

1017: ELSE
1018: BEGIN
1019: select requirement_line_id
1020: into l_check_existence
1021: from csp_requirement_lines
1022: where requirement_line_id = l_line_rec.requirement_line_id;
1023: EXCEPTION
1024: WHEN NO_DATA_FOUND THEN
1025: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_LINE');

Line 1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);

1029: WHEN OTHERS THEN
1030: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1031: fnd_message.set_token('ERR_FIELD', 'l_line_rec.requirement_line_id', FALSE);
1032: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1033: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_LINES', FALSE);
1034: FND_MSG_PUB.ADD;
1035: RAISE EXCP_USER_DEFINED;
1036: END;
1037: END IF;

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 1369: FROM csp_requirement_lines crl, csp_req_line_Details crld

1365:
1366: IF (p_header_id IS NOT NULL) THEN
1367: SELECT count(*)
1368: INTO l_count
1369: FROM csp_requirement_lines crl, csp_req_line_Details crld
1370: WHERE crl.requirement_header_id = p_header_id
1371: AND crl.requirement_line_id = crld.requirement_line_id;
1372:
1373: IF l_count > 0 THEN

Line 1379: DELETE FROM csp_requirement_lines

1375: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'p_header_id', FALSE);
1376: FND_MSG_PUB.ADD;
1377: RAISE EXCP_USER_DEFINED;
1378: ELSE
1379: DELETE FROM csp_requirement_lines
1380: WHERE requirement_header_id = p_header_id;
1381:
1382: DELETE FROM csp_requirement_headers
1383: WHERE requirement_header_id = p_header_id;

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 1480: from csp_requirement_lines crl,

1476: crl.inventory_item_id ,
1477: crl.revision,
1478: crl.required_quantity,
1479: crl.uom_code
1480: from csp_requirement_lines crl,
1481: csp_req_line_details crld
1482: where crld.requirement_line_id(+) = crl.requirement_line_id
1483: and crl.requirement_header_id = p_rqmt_header_id
1484: and crld.source_id is null;

Line 1799: from csp_requirement_lines

1795:
1796: BEGIN
1797: select count(*)
1798: into l_count
1799: from csp_requirement_lines
1800: where requirement_line_id = l_rqmt_line_rec.requirement_line_id;
1801: IF l_count > 0 THEN
1802: fnd_message.set_name('CSP', 'CSP_DUPLICATE_RQMT_LINE');
1803: FND_MSG_PUB.ADD;

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 1952: DELETE FROM csp_Requirement_lines

1948: x_return_status := FND_API.G_RET_STS_SUCCESS;
1949:
1950: IF (p_line_tbl.count > 0) THEN
1951: FOR I IN 1..p_line_Tbl.count LOOP
1952: DELETE FROM csp_Requirement_lines
1953: WHERE requirement_line_id = p_line_tbl(I).requirement_line_id;
1954: END LOOP;
1955: END IF;
1956:

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 2027: from csp_requirement_lines crl,

2023: select crl.requirement_line_id,
2024: crl.inventory_item_id,
2025: crl.uom_code,
2026: crl.required_quantity
2027: from csp_requirement_lines crl,
2028: csp_req_line_details crld
2029: where crld.requirement_line_id(+) = crl.requirement_line_id
2030: and crl.requirement_header_id = p_header_id
2031: and crld.source_id is null;

Line 2056: from csp_requirement_lines crl,

2052:
2053: IF (p_header_id IS NOT NULL) THEN
2054: select count(*)
2055: into l_count
2056: from csp_requirement_lines crl,
2057: csp_req_line_details crld
2058: where crld.requirement_line_id(+) = crl.requirement_line_id
2059: and crl.requirement_header_id = p_header_id
2060: and crld.source_id is null;

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;

Line 2289: FROM csp_requirement_lines c

2285: c.source_organization_id,
2286: c.source_subinventory,
2287: c.shipping_method_code,
2288: c.arrival_date
2289: FROM csp_requirement_lines c
2290: WHERE c.requirement_header_id = p_header_id
2291: AND not exists (select 1 from csp_req_line_Details d where d.requirement_line_id = c.requirement_line_id)
2292: FOR UPDATE of c.order_line_id NOWAIT;
2293:

Line 2336: from csp_requirement_lines crl,

2332:
2333: IF (p_header_id IS NOT NULL) THEN
2334: select count(*)
2335: into l_count
2336: from csp_requirement_lines crl,
2337: csp_req_line_details crld
2338: where crld.requirement_line_id(+) = crl.requirement_line_id
2339: and crl.requirement_header_id = p_header_id
2340: and crld.source_id is null;