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 72: TYPE csp_req_line_details_rec_typ is RECORD(req_line_detail_id NUMBER

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

Line 76: TYPE csp_req_line_details_tabl_typ is table of csp_req_line_details_rec_typ;

72: TYPE csp_req_line_details_rec_typ is RECORD(req_line_detail_id NUMBER
73: ,requirement_line_id NUMBER
74: ,source_type varchar2(30)
75: ,source_id NUMBER);
76: TYPE csp_req_line_details_tabl_typ is table of csp_req_line_details_rec_typ;
77:
78: procedure log(p_procedure in varchar2,p_message in varchar2) as
79: begin
80: --dbms_output.put_line(p_procedure||' - '||p_message);

Line 346: csp_req_line_details d,

342: SELECT count(l.requirement_line_id)
343: into l_partial_line
344: FROM csp_requirement_headers h,
345: csp_requirement_lines l,
346: csp_req_line_details d,
347: oe_order_lines_all oola
348: WHERE h.task_id = p_task_id
349: AND h.task_assignment_id = r_asgn.task_assignment_id
350: AND h.requirement_header_id = l.requirement_header_id

Line 380: csp_req_line_details dio,

376: SELECT COUNT(l.requirement_line_id)
377: into l_fl_rcvd_lines
378: FROM csp_requirement_headers h,
379: csp_requirement_lines l,
380: csp_req_line_details dio,
381: csp_req_line_details dres,
382: oe_order_lines_all oola,
383: mtl_reservations mr
384: WHERE h.task_id = p_task_id

Line 381: csp_req_line_details dres,

377: into l_fl_rcvd_lines
378: FROM csp_requirement_headers h,
379: csp_requirement_lines l,
380: csp_req_line_details dio,
381: csp_req_line_details dres,
382: oe_order_lines_all oola,
383: mtl_reservations mr
384: WHERE h.task_id = p_task_id
385: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 409: csp_req_line_details dio,

405: SELECT ooha.order_number
406: into l_order_number
407: FROM csp_requirement_headers h,
408: csp_requirement_lines l,
409: csp_req_line_details dio,
410: oe_order_lines_all oola,
411: oe_order_headers_all ooha
412: WHERE h.task_id = p_task_id
413: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 438: csp_req_line_details dio,

434: SELECT COUNT(l.requirement_line_id)
435: into l_fl_rcvd_lines
436: FROM csp_requirement_headers h,
437: csp_requirement_lines l,
438: csp_req_line_details dio,
439: csp_req_line_details dres,
440: oe_order_lines_all oola,
441: mtl_reservations mr
442: WHERE h.task_id = p_task_id

Line 439: csp_req_line_details dres,

435: into l_fl_rcvd_lines
436: FROM csp_requirement_headers h,
437: csp_requirement_lines l,
438: csp_req_line_details dio,
439: csp_req_line_details dres,
440: oe_order_lines_all oola,
441: mtl_reservations mr
442: WHERE h.task_id = p_task_id
443: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 470: csp_req_line_details dio,

466: SELECT COUNT(l.requirement_line_id)
467: into l_fl_rcvd_multi_source
468: FROM csp_requirement_headers h,
469: csp_requirement_lines l,
470: csp_req_line_details dio,
471: csp_req_line_details dres,
472: csp_req_line_details dother,
473: oe_order_lines_all oola,
474: mtl_reservations mr

Line 471: csp_req_line_details dres,

467: into l_fl_rcvd_multi_source
468: FROM csp_requirement_headers h,
469: csp_requirement_lines l,
470: csp_req_line_details dio,
471: csp_req_line_details dres,
472: csp_req_line_details dother,
473: oe_order_lines_all oola,
474: mtl_reservations mr
475: WHERE h.task_id = p_task_id

Line 472: csp_req_line_details dother,

468: FROM csp_requirement_headers h,
469: csp_requirement_lines l,
470: csp_req_line_details dio,
471: csp_req_line_details dres,
472: csp_req_line_details dother,
473: oe_order_lines_all oola,
474: mtl_reservations mr
475: WHERE h.task_id = p_task_id
476: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 516: csp_req_line_details d

512: FROM
513: (SELECT l.requirement_line_id
514: FROM csp_requirement_headers h,
515: csp_requirement_lines l,
516: csp_req_line_details d
517: WHERE h.task_id = p_task_id
518: AND h.task_assignment_id = r_asgn.task_assignment_id
519: AND h.requirement_header_id = l.requirement_header_id
520: AND h.address_type IN ('T', 'C', 'P')

Line 526: csp_req_line_details dio,

522: MINUS
523: SELECT l.requirement_line_id
524: FROM csp_requirement_headers h,
525: csp_requirement_lines l,
526: csp_req_line_details dio,
527: csp_req_line_details dres,
528: oe_order_lines_all oola,
529: mtl_reservations mr
530: WHERE h.task_id = p_task_id

Line 527: csp_req_line_details dres,

523: SELECT l.requirement_line_id
524: FROM csp_requirement_headers h,
525: csp_requirement_lines l,
526: csp_req_line_details dio,
527: csp_req_line_details dres,
528: oe_order_lines_all oola,
529: mtl_reservations mr
530: WHERE h.task_id = p_task_id
531: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 574: FROM csp_req_line_details d

570: AND h.task_assignment_id = r_asgn.task_assignment_id
571: AND h.requirement_header_id = l.requirement_header_id
572: AND h.address_type IN ('T', 'C', 'P')
573: AND (SELECT COUNT (d.requirement_line_id)
574: FROM csp_req_line_details d
575: WHERE d.requirement_line_id = l.requirement_line_id) = 0
576: MINUS
577: SELECT l.requirement_line_id
578: FROM csp_requirement_headers h,

Line 580: csp_req_line_details dio,

576: MINUS
577: SELECT l.requirement_line_id
578: FROM csp_requirement_headers h,
579: csp_requirement_lines l,
580: csp_req_line_details dio,
581: csp_req_line_details dres,
582: oe_order_lines_all oola,
583: mtl_reservations mr
584: WHERE h.task_id = p_task_id

Line 581: csp_req_line_details dres,

577: SELECT l.requirement_line_id
578: FROM csp_requirement_headers h,
579: csp_requirement_lines l,
580: csp_req_line_details dio,
581: csp_req_line_details dres,
582: oe_order_lines_all oola,
583: mtl_reservations mr
584: WHERE h.task_id = p_task_id
585: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 632: csp_req_line_details d,

628: SELECT COUNT(l.requirement_line_id)
629: into l_shpd_lines
630: FROM csp_requirement_headers h,
631: csp_requirement_lines l,
632: csp_req_line_details d,
633: oe_order_lines_all oola
634: WHERE h.task_id = p_task_id
635: AND h.task_assignment_id = r_asgn.task_assignment_id
636: AND h.requirement_header_id = l.requirement_header_id

Line 668: csp_req_line_details d,

664: SELECT ooha.order_number
665: INTO l_order_number
666: FROM csp_requirement_headers h,
667: csp_requirement_lines l,
668: csp_req_line_details d,
669: oe_order_lines_all oola,
670: oe_order_headers_all ooha
671: WHERE h.task_assignment_id = r_asgn.task_assignment_id
672: AND h.task_id = p_task_id

Line 696: csp_req_line_details d,

692: SELECT COUNT(l.requirement_line_id)
693: into l_ship_multi_src
694: FROM csp_requirement_headers h,
695: csp_requirement_lines l,
696: csp_req_line_details d,
697: csp_req_line_details dother,
698: oe_order_lines_all oola
699: WHERE h.task_id = p_task_id
700: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 697: csp_req_line_details dother,

693: into l_ship_multi_src
694: FROM csp_requirement_headers h,
695: csp_requirement_lines l,
696: csp_req_line_details d,
697: csp_req_line_details dother,
698: oe_order_lines_all oola
699: WHERE h.task_id = p_task_id
700: AND h.task_assignment_id = r_asgn.task_assignment_id
701: AND h.requirement_header_id = l.requirement_header_id

Line 734: csp_req_line_details d

730: FROM
731: (SELECT l.requirement_line_id
732: FROM csp_requirement_headers h,
733: csp_requirement_lines l,
734: csp_req_line_details d
735: WHERE h.task_id = p_task_id
736: AND h.task_assignment_id = r_asgn.task_assignment_id
737: AND h.requirement_header_id = l.requirement_header_id
738: AND l.requirement_line_id = d.requirement_line_id

Line 743: csp_req_line_details d,

739: MINUS
740: SELECT l.requirement_line_id
741: FROM csp_requirement_headers h,
742: csp_requirement_lines l,
743: csp_req_line_details d,
744: oe_order_lines_all oola
745: WHERE h.task_id = p_task_id
746: AND h.task_assignment_id = r_asgn.task_assignment_id
747: AND h.requirement_header_id = l.requirement_header_id

Line 782: FROM csp_req_line_details d

778: WHERE h.task_id = p_task_id
779: AND h.task_assignment_id = r_asgn.task_assignment_id
780: AND h.requirement_header_id = l.requirement_header_id
781: AND (SELECT COUNT (d.requirement_line_id)
782: FROM csp_req_line_details d
783: WHERE d.requirement_line_id = l.requirement_line_id) = 0
784: MINUS
785: SELECT l.requirement_line_id
786: FROM csp_requirement_headers h,

Line 788: csp_req_line_details d,

784: MINUS
785: SELECT l.requirement_line_id
786: FROM csp_requirement_headers h,
787: csp_requirement_lines l,
788: csp_req_line_details d,
789: oe_order_lines_all oola
790: WHERE h.task_id = p_task_id
791: AND h.task_assignment_id = r_asgn.task_assignment_id
792: AND h.requirement_header_id = l.requirement_header_id

Line 811: csp_req_line_details d,

807: SELECT MAX(oel.request_date)
808: into l_old_arrival_date
809: FROM csp_requirement_headers h,
810: csp_requirement_lines l,
811: csp_req_line_details d,
812: oe_order_lines_all oel
813: WHERE h.task_id = p_task_id
814: AND h.task_assignment_id = r_asgn.task_assignment_id
815: AND h.requirement_header_id = l.requirement_header_id

Line 897: csp_req_line_details d,

893: SELECT MAX(oel.request_date)
894: into l_old_arrival_date
895: FROM csp_requirement_headers h,
896: csp_requirement_lines l,
897: csp_req_line_details d,
898: oe_order_lines_all oel
899: WHERE h.task_id = p_task_id
900: AND h.task_assignment_id = r_asgn.task_assignment_id
901: AND h.requirement_header_id = l.requirement_header_id

Line 1323: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;

1319: l_ship_to_location_id NUMBER;
1320: l_ship_methode_count NUMBER;
1321: l_temp_line_id NUMBER;
1322: l_final_available_list CSP_SCH_INT_PVT.CSP_AVAILABILITY_TBL_TYPE ;
1323: l_req_line_details_tbl CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ;
1324: l_address_type varchar2(3);
1325: --hehxxx
1326: l_search_method varchar2(30) := fnd_profile.value('CSP_PART_SEARCH_METHOD_SCHEDULER');
1327: x_options CSP_SCH_INT_PVT.csp_sch_options_tbl_typ;

Line 1394: csp_req_line_details dio,

1390: SELECT COUNT(l.requirement_line_id)
1391: into l_fl_rcvd_lines
1392: FROM csp_requirement_headers h,
1393: csp_requirement_lines l,
1394: csp_req_line_details dio,
1395: csp_req_line_details dres,
1396: oe_order_lines_all oola,
1397: mtl_reservations mr
1398: WHERE h.task_id = p_task_id

Line 1395: csp_req_line_details dres,

1391: into l_fl_rcvd_lines
1392: FROM csp_requirement_headers h,
1393: csp_requirement_lines l,
1394: csp_req_line_details dio,
1395: csp_req_line_details dres,
1396: oe_order_lines_all oola,
1397: mtl_reservations mr
1398: WHERE h.task_id = p_task_id
1399: AND h.task_assignment_id = r_asgn.task_assignment_id

Line 1447: csp_req_line_details d,

1443: SELECT COUNT(l.requirement_line_id)
1444: into l_shpd_lines
1445: FROM csp_requirement_headers h,
1446: csp_requirement_lines l,
1447: csp_req_line_details d,
1448: oe_order_lines_all oola
1449: WHERE h.task_id = p_task_id
1450: AND h.task_assignment_id = r_asgn.task_assignment_id
1451: AND h.requirement_header_id = l.requirement_header_id

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

1583: l_temp_options := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
1584: l_final_option := CSP_SCH_INT_PVT.CSP_SHIP_PARAMETERS_TBL_TYPE() ;
1585: l_res_ship_parameters := CSP_SCH_INT_PVT.CSP_ORGS_SHIP_PARAM_TBL_TYPE();
1586: l_org_ship_methode := org_ship_methodes_tbl_type();
1587: l_req_line_details_tbl := CSP_SCH_INT_PVT.csp_req_line_details_tabl_typ();
1588:
1589: l_resources.extend;
1590: l_resources(1).resource_id := p_options.resource_id ;
1591: l_resources(1).resource_type := p_options.resource_type ;

Line 1681: csp_req_line_details_pkg.insert_row(

1677: l_reservation_parts.revision := cap.supplied_item_rev;
1678: l_reservation_id := CSP_SCH_INT_PVT.CREATE_RESERVATION(l_reservation_parts,x_return_status,x_msg_data);
1679: if x_return_status = FND_API.G_RET_STS_SUCCESS then
1680: l_req_line_details_id := null;
1681: csp_req_line_details_pkg.insert_row(
1682: l_req_line_details_id
1683: ,cap.requirement_line_id
1684: ,fnd_global.user_id
1685: ,sysdate

Line 1724: csp_req_line_details_pkg.insert_row(

1720: return;
1721: end if;
1722: for i in 1..l_parts_lines.count loop
1723: l_req_line_details_id := null;
1724: csp_req_line_details_pkg.insert_row(
1725: l_req_line_details_id
1726: ,l_parts_lines(i).requirement_line_id
1727: ,fnd_global.user_id
1728: ,sysdate

Line 1800: csp_req_line_details_pkg.insert_row(

1796: end if;
1797: for i in 1..l_parts_lines.count loop
1798: log('choose_option','Creating requirement line details');
1799: l_req_line_details_id := null;
1800: csp_req_line_details_pkg.insert_row(
1801: l_req_line_details_id
1802: ,l_parts_lines(i).requirement_line_id
1803: ,fnd_global.user_id
1804: ,sysdate

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

2166: ROLLBACK TO choose_options;
2167: return;
2168: END IF;
2169: FOR K IN 1..l_req_line_details_tbl.count LOOP
2170: csp_req_line_details_pkg.insert_row(l_req_line_details_tbl(K).REQ_LINE_DETAIL_ID
2171: ,l_req_line_details_tbl(K).REQUIREMENT_LINE_ID
2172: ,fnd_global.user_id
2173: ,sysdate
2174: ,fnd_global.user_id

Line 2436: from csp_req_line_details crld

2432: l_module_name varchar2(100);
2433:
2434: CURSOR get_reservations is
2435: select crld.source_id , crld.req_line_detail_id
2436: from csp_req_line_details crld
2437: ,csp_requirement_lines crl
2438: ,csp_requirement_headers crh
2439: where crh.task_assignment_id = p_task_assignment_id
2440: and crl.requirement_header_id = crh.requirement_header_id

Line 2446: from csp_req_line_details crld

2442: and crld.source_type = 'RES' ;
2443:
2444: CURSOR get_orders is
2445: select oeh.header_id, crld.req_line_detail_id, crh.address_type
2446: from csp_req_line_details crld
2447: ,csp_requirement_lines crl
2448: ,csp_requirement_headers crh
2449: ,oe_order_lines_all oel
2450: ,oe_order_headers_all oeh

Line 2466: from csp_req_line_details crld,oe_order_lines_all oel

2462: where header_id = c_header_id;
2463:
2464: cursor get_line_details(c_order_header_id Number) is
2465: select REQ_LINE_DETAIL_ID
2466: from csp_req_line_details crld,oe_order_lines_all oel
2467: where crld.source_id = oel.line_id
2468: and crld.source_type = 'IO'
2469: and oel.header_id = c_order_header_id;
2470:

Line 2500: csp_req_line_details dio,

2496: SELECT COUNT(l.requirement_line_id)
2497: into l_fl_rcvd_lines
2498: FROM csp_requirement_headers h,
2499: csp_requirement_lines l,
2500: csp_req_line_details dio,
2501: csp_req_line_details dres,
2502: oe_order_lines_all oola,
2503: mtl_reservations mr
2504: WHERE h.task_assignment_id = p_task_assignment_id

Line 2501: csp_req_line_details dres,

2497: into l_fl_rcvd_lines
2498: FROM csp_requirement_headers h,
2499: csp_requirement_lines l,
2500: csp_req_line_details dio,
2501: csp_req_line_details dres,
2502: oe_order_lines_all oola,
2503: mtl_reservations mr
2504: WHERE h.task_assignment_id = p_task_assignment_id
2505: AND h.address_type IN ('T', 'C', 'P')

Line 2532: csp_req_line_details d,

2528: SELECT COUNT(l.requirement_line_id)
2529: into l_shpd_lines
2530: FROM csp_requirement_headers h,
2531: csp_requirement_lines l,
2532: csp_req_line_details d,
2533: oe_order_lines_all oola
2534: WHERE h.task_assignment_id = p_task_assignment_id
2535: AND h.requirement_header_id = l.requirement_header_id
2536: and h.address_type in ('C', 'T', 'P')

Line 2579: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);

2575: --x_return_status := FND_API.G_RET_STS_SUCCESS;
2576: rollback to CLEAN_MATERIAL_TRANSACTION;
2577: return;
2578: ELSE
2579: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);
2580: END IF;
2581: END LOOP;
2582: close get_reservations;
2583:

Line 2669: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);

2665: fnd_log.string(fnd_log.level_statement, l_module_name,
2666: 'deleting req_line_details for l_req_details_line_id = ' || l_req_details_line_id);
2667: end if;
2668:
2669: CSP_REQ_LINE_DETAILS_PKG.Delete_Row(l_req_details_line_id);
2670: END LOOP;
2671: CLOSE get_line_details;
2672:
2673: END LOOP;

Line 2815: from csp_req_line_details crld

2811: ,x_msg_count OUT NOCOPY NUMBER) IS
2812:
2813: CURSOR get_orders is
2814: select distinct oeh.header_id, oel.line_id
2815: from csp_req_line_details crld
2816: ,csp_requirement_lines crl
2817: ,csp_requirement_headers crh
2818: ,oe_order_lines_all oel
2819: ,oe_order_headers_all oeh

Line 8051: from csp_req_line_details crld

8047: l_cleanup_needed Varchar2(1) := 'N';
8048:
8049: CURSOR get_reservations is
8050: select crld.source_id , crld.req_line_detail_id
8051: from csp_req_line_details crld
8052: ,csp_requirement_lines crl
8053: ,csp_requirement_headers crh
8054: where crh.task_id = l_task_id
8055: and crl.requirement_header_id = crh.requirement_header_id

Line 8061: from csp_req_line_details crld

8057: and crld.source_type = 'RES' ;
8058:
8059: CURSOR get_orders is
8060: select oeh.header_id, crld.req_line_detail_id
8061: from csp_req_line_details crld
8062: ,csp_requirement_lines crl
8063: ,csp_requirement_headers crh
8064: ,oe_order_lines_all oel
8065: ,oe_order_headers_all oeh

Line 8087: from csp_req_line_details crld,oe_order_lines_all oel

8083: and ( CANCELLED_FLAG = 'Y' or rejected_flag = 'Y');
8084:
8085: cursor get_line_details(c_order_header_id Number) is
8086: select REQ_LINE_DETAIL_ID
8087: from csp_req_line_details crld,oe_order_lines_all oel
8088: where crld.source_id = oel.line_id
8089: and crld.source_type = 'IO'
8090: and oel.header_id = c_order_header_id;
8091:

Line 8109: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

8105: CSP_SCH_INT_PVT.CANCEL_RESERVATION(l_reserv_id,l_return_status,x_msg_data,x_msg_count);
8106: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
8107: x_return_status := FND_API.G_RET_STS_SUCCESS;
8108: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
8109: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
8110: END IF;
8111: END LOOP;
8112: close get_reservations;
8113: OPEN get_orders;

Line 8129: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;

8125: open get_line_details(l_order_id);
8126: LOOP
8127: FETCH get_line_details INTO l_req_details_line_id;
8128: EXIT WHEN get_line_details% NOTFOUND;
8129: delete from csp_req_line_details where req_line_detail_id = l_req_details_line_id;
8130: END LOOP;
8131: CLOSE get_line_details;
8132: END IF;
8133: END IF;

Line 8150: oe_order_lines_all oola,csp_req_line_details crld,

8146: crld.requirement_line_id requirement_line_id,rcl.quantity_shipped quantity_shipped,
8147: rcl.quantity_received quantity_received,crld.req_line_detail_id req_line_detail_id
8148: from mtl_material_transactions mmt,RCV_SHIPMENT_headers rsh,
8149: rcv_shipment_lines rcl,
8150: oe_order_lines_all oola,csp_req_line_details crld,
8151: csp_requirement_lines crl,
8152: csp_requirement_headers crh
8153: where mmt.transaction_id = p_transaction_id
8154: and mmt.shipment_number = rsh.shipment_num

Line 8170: oe_order_lines_all oola,csp_req_line_details crld,

8166: crld.source_id line_id, mmt.transaction_uom uom,crh.need_by_date need_by_date,
8167: crld.requirement_line_id requirement_line_id, mmt.transaction_quantity quantity_shipped,
8168: mmt.transaction_quantity quantity_received,crld.req_line_detail_id req_line_detail_id
8169: from mtl_material_transactions mmt,
8170: oe_order_lines_all oola,csp_req_line_details crld,
8171: csp_requirement_lines crl,csp_requirement_headers crh
8172: where mmt.transaction_id = p_transaction_id
8173: and oola.source_document_id = mmt.transaction_source_id
8174: and crld.source_id = oola.line_id

Line 8202: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id

8198: ,x_return_status
8199: ,x_msg_data );
8200: l_req_line_detali_id := NULL;
8201: IF l_reservation_id IS NOT NULL AND l_reservation_id >0 THEN
8202: csp_req_line_details_pkg.insert_row(px_req_line_detail_id => l_req_line_detali_id
8203: ,p_requirement_line_id => grd.requirement_line_id
8204: ,p_created_by => FND_GLOBAL.user_id
8205: ,p_creation_date => sysdate
8206: ,p_last_updated_by => FND_GLOBAL.user_id

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

8209: ,p_source_type => 'RES'
8210: ,p_source_id => l_reservation_id );
8211:
8212: IF grd.quantity_shipped = grd.quantity_received THEN
8213: csp_req_line_details_pkg.delete_row(grd.req_line_detail_id);
8214: END IF;
8215: END IF;
8216: END LOOP;
8217: END CREATE_RES_FOR_RCV_TRANXS;

Line 8368: csp_req_line_details dio,

8364: dres.req_line_detail_id,
8365: h.requirement_header_id
8366: FROM csp_requirement_headers h,
8367: csp_requirement_lines l,
8368: csp_req_line_details dio,
8369: csp_req_line_details dres,
8370: oe_order_lines_all oola,
8371: mtl_reservations mr
8372: WHERE h.task_id = p_task_id

Line 8369: csp_req_line_details dres,

8365: h.requirement_header_id
8366: FROM csp_requirement_headers h,
8367: csp_requirement_lines l,
8368: csp_req_line_details dio,
8369: csp_req_line_details dres,
8370: oe_order_lines_all oola,
8371: mtl_reservations mr
8372: WHERE h.task_id = p_task_id
8373: AND h.task_assignment_id = p_task_asgn_id

Line 8399: FROM csp_req_line_details

8395: l_resource_type_name varchar2(2000);
8396:
8397: cursor req_line_dtl_rows (v_req_line_id number) is
8398: SELECT req_line_detail_id
8399: FROM csp_req_line_details
8400: WHERE requirement_line_id = v_req_line_id
8401: AND source_type = 'RES';
8402:
8403: CURSOR resource_org IS

Line 8553: csp_req_line_details_pkg.delete_row(r_req_line_dtl_rec.req_line_detail_id);

8549:
8550: for r_req_line_dtl_rec in req_line_dtl_rows(old_res_record.requirement_line_id)
8551: loop
8552: log('move_parts_on_reassign', 'deleting req_line_detail_id=' || r_req_line_dtl_rec.req_line_detail_id);
8553: csp_req_line_details_pkg.delete_row(r_req_line_dtl_rec.req_line_detail_id);
8554: end loop;
8555:
8556: log('move_parts_on_reassign', 'before inserting a new req_line_detail...');
8557: l_req_line_detail_id := null;

Line 8558: csp_req_line_details_pkg.Insert_Row(

8554: end loop;
8555:
8556: log('move_parts_on_reassign', 'before inserting a new req_line_detail...');
8557: l_req_line_detail_id := null;
8558: csp_req_line_details_pkg.Insert_Row(
8559: px_REQ_LINE_DETAIL_ID => l_req_line_detail_id,
8560: p_REQUIREMENT_LINE_ID => old_res_record.requirement_line_id,
8561: p_CREATED_BY => FND_GLOBAL.user_id,
8562: p_CREATION_DATE => sysdate,