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_SCH_INT_PVT dependencies on CSP_REQ_LINE_DETAILS

Line 70: TYPE csp_req_line_details_rec_typ is RECORD(req_line_detail_id NUMBER

66: to_org NUMBER,
67: shipping_methode varchar2(30));
68:
69: TYPE org_ship_methodes_tbl_type IS TABLE OF csp_sch_int_pvt.org_ship_methodes ;
70: TYPE csp_req_line_details_rec_typ is RECORD(req_line_detail_id NUMBER
71: ,requirement_line_id NUMBER
72: ,source_type varchar2(30)
73: ,source_id NUMBER);
74: TYPE csp_req_line_details_tabl_typ is table of csp_req_line_details_rec_typ;

Line 74: TYPE csp_req_line_details_tabl_typ is table of csp_req_line_details_rec_typ;

70: TYPE csp_req_line_details_rec_typ is RECORD(req_line_detail_id NUMBER
71: ,requirement_line_id NUMBER
72: ,source_type varchar2(30)
73: ,source_id NUMBER);
74: TYPE csp_req_line_details_tabl_typ is table of csp_req_line_details_rec_typ;
75:
76: PROCEDURE GET_ORGANIZATION_SUBINV(p_resources IN CSP_SCH_INT_PVT.csp_sch_resource_tbl_typ
77: ,x_resource_org_subinv OUT NOCOPY CSP_SCH_INT_PVT.csp_resource_org_tbl_typ
78: ,x_return_status OUT NOCOPY VARCHAR2

Line 405: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;

401: l_ship_to_location_id NUMBER;
402: l_ship_methode_count NUMBER;
403: l_temp_line_id NUMBER;
404: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
405: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;
406: l_address_type varchar2(3);
407: BEGIN
408: savepoint choose_options;
409: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 424: l_req_line_details_tbl := CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ();

420: l_temp_options := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
421: l_final_option := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
422: l_res_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
423: l_org_ship_methode := org_ship_methodes_tbl_type();
424: l_req_line_details_tbl := CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ();
425:
426:
427: l_resources.extend;
428: l_resources(1).resource_id := p_options.resource_id ;

Line 702: csp_req_line_details_pkg.insert_row(l_req_line_details_tbl(K).REQ_LINE_DETAIL_ID

698: ROLLBACK TO choose_options;
699: return;
700: END IF;
701: FOR K IN 1..l_req_line_details_tbl.count LOOP
702: csp_req_line_details_pkg.insert_row(l_req_line_details_tbl(K).REQ_LINE_DETAIL_ID
703: ,l_req_line_details_tbl(K).REQUIREMENT_LINE_ID
704: ,fnd_global.user_id
705: ,sysdate
706: ,fnd_global.user_id

Line 930: from csp_req_line_details crld

926: l_status varchar2(30);
927:
928: CURSOR get_reservations is
929: select crld.source_id , crld.req_line_detail_id
930: from csp_req_line_details crld
931: ,csp_requirement_lines crl
932: ,csp_requirement_headers crh
933: where crh.task_assignment_id = p_task_assignment_id
934: and crl.requirement_header_id = crh.requirement_header_id

Line 940: from csp_req_line_details crld

936: and crld.source_type = 'RES' ;
937:
938: CURSOR get_orders is
939: select oeh.header_id, crld.req_line_detail_id
940: from csp_req_line_details crld
941: ,csp_requirement_lines crl
942: ,csp_requirement_headers crh
943: ,oe_order_lines_all oel
944: ,oe_order_headers_all oeh

Line 960: from csp_req_line_details crld,oe_order_lines_all oel

956: where header_id = c_header_id;
957:
958: cursor get_line_details(c_order_header_id Number) is
959: select REQ_LINE_DETAIL_ID
960: from csp_req_line_details crld,oe_order_lines_all oel
961: where crld.source_id = oel.line_id
962: and crld.source_type = 'IO'
963: and oel.header_id = c_order_header_id;
964:

Line 986: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

982: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984: exit;
985: ELSE
986: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
987: END IF;
988: END LOOP;
989: close get_reservations;
990: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1012: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

1008: open get_line_details(l_order_id);
1009: LOOP
1010: FETCH get_line_details INTO l_req_details_line_id;
1011: EXIT WHEN get_line_details% NOTFOUND;
1012: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
1013: END LOOP;
1014: CLOSE get_line_details;
1015: END IF;
1016: END IF;

Line 1128: from csp_req_line_details crld

1124: ,x_msg_count OUT NOCOPY NUMBER) IS
1125:
1126: CURSOR get_orders is
1127: select distinct oeh.header_id, oel.line_id
1128: from csp_req_line_details crld
1129: ,csp_requirement_lines crl
1130: ,csp_requirement_headers crh
1131: ,oe_order_lines_all oel
1132: ,oe_order_headers_all oeh

Line 5509: from csp_req_line_details crld

5505: l_cleanup_needed Varchar2(1) := 'N';
5506:
5507: CURSOR get_reservations is
5508: select crld.source_id , crld.req_line_detail_id
5509: from csp_req_line_details crld
5510: ,csp_requirement_lines crl
5511: ,csp_requirement_headers crh
5512: where crh.task_id = l_task_id
5513: and crl.requirement_header_id = crh.requirement_header_id

Line 5519: from csp_req_line_details crld

5515: and crld.source_type = 'RES' ;
5516:
5517: CURSOR get_orders is
5518: select oeh.header_id, crld.req_line_detail_id
5519: from csp_req_line_details crld
5520: ,csp_requirement_lines crl
5521: ,csp_requirement_headers crh
5522: ,oe_order_lines_all oel
5523: ,oe_order_headers_all oeh

Line 5545: from csp_req_line_details crld,oe_order_lines_all oel

5541: and ( CANCELLED_FLAG = 'Y' or rejected_flag = 'Y');
5542:
5543: cursor get_line_details(c_order_header_id Number) is
5544: select REQ_LINE_DETAIL_ID
5545: from csp_req_line_details crld,oe_order_lines_all oel
5546: where crld.source_id = oel.line_id
5547: and crld.source_type = 'IO'
5548: and oel.header_id = c_order_header_id;
5549:

Line 5567: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

5563: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,l_return_status,x_msg_data,x_msg_count);
5564: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5565: x_return_status := FND_API.G_RET_STS_SUCCESS;
5566: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5567: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
5568: END IF;
5569: END LOOP;
5570: close get_reservations;
5571: OPEN get_orders;

Line 5587: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

5583: open get_line_details(l_order_id);
5584: LOOP
5585: FETCH get_line_details INTO l_req_details_line_id;
5586: EXIT WHEN get_line_details% NOTFOUND;
5587: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
5588: END LOOP;
5589: CLOSE get_line_details;
5590: END IF;
5591: END IF;

Line 5608: oe_order_lines_all oola,csp_req_line_details crld,

5604: crld.requirement_line_id requirement_line_id,rcl.quantity_shipped quantity_shipped,
5605: rcl.quantity_received quantity_received,crld.req_line_detail_id req_line_detail_id
5606: from mtl_material_transactions mmt,RCV_SHIPMENT_headers rsh,
5607: rcv_shipment_lines rcl,
5608: oe_order_lines_all oola,csp_req_line_details crld,
5609: csp_requirement_lines crl,
5610: csp_requirement_headers crh
5611: where mmt.transaction_id = p_transaction_id
5612: and mmt.shipment_number = rsh.shipment_num

Line 5628: oe_order_lines_all oola,csp_req_line_details crld,

5624: crld.source_id line_id, mmt.transaction_uom uom,crh.need_by_date need_by_date,
5625: crld.requirement_line_id requirement_line_id, mmt.transaction_quantity quantity_shipped,
5626: mmt.transaction_quantity quantity_received,crld.req_line_detail_id req_line_detail_id
5627: from mtl_material_transactions mmt,
5628: oe_order_lines_all oola,csp_req_line_details crld,
5629: csp_requirement_lines crl,csp_requirement_headers crh
5630: where mmt.transaction_id = p_transaction_id
5631: and oola.source_document_id = mmt.transaction_source_id
5632: and crld.source_id = oola.line_id

Line 5660: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id

5656: ,x_return_status
5657: ,x_msg_data );
5658: l_req_line_detali_id := NULL;
5659: IF l_reservation_id IS NOT NULL AND l_reservation_id >0 THEN
5660: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
5661: ,p_requirement_line_id => grd.requirement_line_id
5662: ,p_created_by => FND_GLOBAL.user_id
5663: ,p_creation_date => sysdate
5664: ,p_last_updated_by => FND_GLOBAL.user_id

Line 5671: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);

5667: ,p_source_type => 'RES'
5668: ,p_source_id => l_reservation_id );
5669:
5670: IF grd.quantity_shipped = grd.quantity_received THEN
5671: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);
5672: END IF;
5673: END IF;
5674: END LOOP;
5675: END CREATE_RES_FOR_RCV_TRANXS;