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_SCH_INT_PVT

Line 170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_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
170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
171: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
172: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
173: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;
174: l_req_line_Dtl_id NUMBER;

Line 171: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;

167: j NUMBER;
168:
169: --Record types and tbl types for finding availability of parts
170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
171: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
172: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
173: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;
174: l_req_line_Dtl_id NUMBER;
175: l_timezone_id NUMBER;

Line 172: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

168:
169: --Record types and tbl types for finding availability of parts
170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
171: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
172: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
173: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;
174: l_req_line_Dtl_id NUMBER;
175: l_timezone_id NUMBER;
176:

Line 173: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;

169: --Record types and tbl types for finding availability of parts
170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
171: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;
172: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;
173: l_resource_rec csp_sch_int_pvt.csp_sch_resources_rec_typ;
174: l_req_line_Dtl_id NUMBER;
175: l_timezone_id NUMBER;
176:
177: CURSOR rs_loc_cur(p_resource_type VARCHAR2, p_resource_id NUMBER) IS

Line 263: -- call csp_sch_int_pvt.check_parts_availability()

259: END LOOP;
260: IF l_parts_list_tbl.count > 0 THEN
261:
262: IF sysdate < l_header_rec.need_by_date THEN
263: -- call csp_sch_int_pvt.check_parts_availability()
264: csp_sch_int_pvt.check_parts_availability(
265: p_resource => l_resource_rec,
266: p_organization_id => l_header_rec.dest_organization_id,
267: p_subinv_code => null,

Line 264: csp_sch_int_pvt.check_parts_availability(

260: IF l_parts_list_tbl.count > 0 THEN
261:
262: IF sysdate < l_header_rec.need_by_date THEN
263: -- call csp_sch_int_pvt.check_parts_availability()
264: csp_sch_int_pvt.check_parts_availability(
265: p_resource => l_resource_rec,
266: p_organization_id => l_header_rec.dest_organization_id,
267: p_subinv_code => null,
268: p_need_by_date => l_header_rec.need_by_date,

Line 810: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;

806: l_resource_att NUMBER := 0;
807: l_resource_onhand NUMBER := 0;
808: l_resource_org_id NUMBER;
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;

Line 871: csp_sch_int_pvt.check_local_inventory(p_org_id => l_resource_org_id,

867:
868: l_qty_to_Reserve := l_line_Rec.quantity - l_line_rec.ordered_quantity;
869:
870: IF (l_resource_org_id IS NOT NULL AND l_resource_subinv IS NOT NULL) THEN
871: csp_sch_int_pvt.check_local_inventory(p_org_id => l_resource_org_id,
872: p_subinv_code => l_resource_subinv,
873: p_item_id => l_line_rec.inventory_item_id,
874: p_revision => l_line_Rec.revision,
875: x_att => l_resource_att,

Line 896: l_local_reservation_id := csp_sch_int_pvt.create_reservation(

892: l_reservation_rec.item_uom_code := l_line_rec.unit_of_measure;
893: l_reservation_rec.quantity_needed := l_qty_to_reserve;
894: l_reservation_rec.sub_inventory_code := l_resource_subinv;
895:
896: l_local_reservation_id := csp_sch_int_pvt.create_reservation(
897: p_reservation_parts => l_reservation_rec,
898: x_return_status => l_return_status,
899: --x_msg_count => l_msg_Count,
900: x_msg_data => l_msg_data

Line 1145: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;

1141: l_oe_line_rec Line_rec_type;
1142: l_po_line_tbl Line_Tbl_type;
1143: l_po_line_Rec Line_Rec_Type;
1144:
1145: l_reservation_rec CSP_SCH_INT_PVT.RESERVATION_REC_TYP;
1146: l_reservation_id NUMBER;
1147:
1148: l_req_line_dtl_id NUMBER;
1149: BEGIN

Line 1192: l_reservation_id := csp_sch_int_pvt.create_reservation(

1188: l_reservation_rec.item_uom_code := l_line_rec.unit_of_measure;
1189: l_reservation_rec.quantity_needed := l_line_rec.ordered_quantity;
1190: l_reservation_rec.sub_inventory_code := l_line_rec.source_subinventory;
1191:
1192: l_reservation_id := csp_sch_int_pvt.create_reservation(
1193: p_reservation_parts => l_reservation_rec,
1194: x_return_status => l_return_status,
1195: x_msg_data => l_msg_data
1196: );

Line 2013: l_parts_list_rec csp_sch_int_pvt.csp_parts_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;
2016: I NUMBER;
2017: J NUMBER;

Line 2014: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;

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;
2016: I NUMBER;
2017: J NUMBER;
2018: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 2015: l_avail_list_tbl csp_sch_int_pvt.available_parts_tbl_typ1;

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;
2016: I NUMBER;
2017: J NUMBER;
2018: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2019: l_msg_count NUMBER;

Line 2104: -- call csp_sch_int_pvt.check_parts_availability()

2100: END LOOP;
2101:
2102: IF (l_parts_list_Tbl.count > 0) THEN
2103: FND_MSG_PUB.initialize;
2104: -- call csp_sch_int_pvt.check_parts_availability()
2105: csp_sch_int_pvt.check_parts_availability(
2106: p_resource => null,
2107: p_organization_id => l_header_rec.dest_organization_id,
2108: p_subinv_code => l_header_rec.dest_subinventory,

Line 2105: csp_sch_int_pvt.check_parts_availability(

2101:
2102: IF (l_parts_list_Tbl.count > 0) THEN
2103: FND_MSG_PUB.initialize;
2104: -- call csp_sch_int_pvt.check_parts_availability()
2105: csp_sch_int_pvt.check_parts_availability(
2106: p_resource => null,
2107: p_organization_id => l_header_rec.dest_organization_id,
2108: p_subinv_code => l_header_rec.dest_subinventory,
2109: p_need_by_date => l_header_rec.need_by_date,