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.PO_REQCHANGEREQUESTWF_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 306: FROM oe_order_headers_all ooh, oe_order_lines_all ool , po_requisition_lines_all prl ,

302:
303:
304: SELECT ool.org_id
305: INTO l_org_id
306: FROM oe_order_headers_all ooh, oe_order_lines_all ool , po_requisition_lines_all prl ,
307: po_system_parameters_all psp
308: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prl.requisition_header_id)
309: AND p_req_line_id IS NOT null
310: AND prl.requisition_line_id = p_req_line_id

Line 321: from po_requisition_lines_all prl,

317:
318: /*
319: SELECT ooh.ORG_ID
320: INTO l_org_id
321: from po_requisition_lines_all prl,
322: po_requisition_headers_all prh,
323: oe_order_headers_all ooh,
324: po_system_parameters_all psp
325: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)

Line 351: from po_requisition_lines_all prl,

347: begin
348:
349: SELECT prh.org_id
350: INTO l_org_id
351: from po_requisition_lines_all prl,
352: po_requisition_headers_all prh
353: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
354: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
355: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)

Line 766: update po_requisition_lines_all

762: nonrecoverable_tax=l_nonrecoverable_tax
763: where distribution_id=p_req_distribution_id;
764:
765: x_progress :='001';
766: update po_requisition_lines_all
767: set
768: quantity = quantity + decode(p_new_quantity,null,0,(p_new_quantity-p_old_quantity)),
769: amount = amount + decode(p_new_dist_amount,null,0,(p_new_dist_amount - p_old_dist_amount)),
770: currency_amount = currency_amount + decode(p_new_currency_dist_amount,null,0,

Line 841: update po_requisition_lines_all

837: close l_distributions_csr;
838: end if;
839: x_progress :='0042-';
840:
841: update po_requisition_lines_all
842: set need_by_date=nvl(p_new_need_by_date, need_by_date),
843: unit_price=nvl(p_new_unit_price, unit_price),
844: currency_unit_price=nvl(p_new_currency_unit_price, currency_unit_price), assignment_start_date = nvl(p_new_start_date, assignment_start_date),
845: assignment_end_date = nvl(p_new_end_date, assignment_end_date)

Line 907: update po_requisition_lines_all

903: set cancel_flag='Y'
904: where requisition_header_id=l_header_id;
905: else
906: -- it is line level
907: update po_requisition_lines_all
908: set cancel_flag='Y'
909: where requisition_line_id=l_line_id;
910: end if;
911: else

Line 1861: po_requisition_lines_all por

1857: from
1858: po_change_requests pcr,
1859: po_change_requests pcr4,
1860: po_change_requests pcr5,
1861: po_requisition_lines_all por
1862: where
1863: pcr.change_request_group_id=p_change_request_group_id
1864: and pcr.parent_change_request_id=pcr4.change_request_id
1865: and pcr4.change_request_group_id=pcr5.change_request_group_id

Line 2349: (SELECT LINE_LOCATION_ID FROM po_requisition_lines_all WHERE requisition_line_id= l_document_line_id);

2345: x_progress:='ACCEPTANCE:006-'||to_char(l_change_request_id);
2346:
2347: -- Bug# 15875594 Changes Starts
2348: SELECT PO_LINE_ID INTO l_po_line_id FROM po_line_locations_all WHERE LINE_LOCATION_ID =
2349: (SELECT LINE_LOCATION_ID FROM po_requisition_lines_all WHERE requisition_line_id= l_document_line_id);
2350:
2351: -- copy change request attachments to req line.
2352: fnd_attached_documents2_pkg.copy_attachments('REQ_LINE_CHANGES',l_document_line_id,NULL,NULL,NULL,NULL,'REQ_LINES',
2353: l_document_line_id,NULL,NULL,NULL,NULL,fnd_global.user_id,fnd_global.login_id);

Line 3016: l_req_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%TYPE;

3012: l_dist_quantity number;
3013: l_new_ship_quantity number;
3014: l_old_ship_quantity number;
3015: l_item_id number;
3016: l_req_uom po_requisition_lines_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
3017: l_po_uom po_line_locations_all.UNIT_MEAS_LOOKUP_CODE%TYPE;
3018: l_old_amount number;
3019: l_new_amount number;
3020: l_old_start_date date;

Line 3091: po_requisition_lines_all prl,

3087: max(prl.matching_basis),
3088: max(pcr.requester_id) requester_id -- Bug # 3862383
3089: from po_change_requests pcr,
3090: po_line_locations_all pll,
3091: po_requisition_lines_all prl,
3092: po_headers_all poh,
3093: po_releases_all por,
3094: po_lines_all pol
3095: where pcr.change_request_group_id=l_change_request_group_id

Line 3147: po_requisition_lines_all prl,

3143: prl.matching_basis,
3144: pcr.requester_id requester_id -- Bug # 3862383
3145: from po_change_requests pcr,
3146: po_line_locations_all pll,
3147: po_requisition_lines_all prl,
3148: po_headers_all poh,
3149: po_releases_all por,
3150: po_lines_all pol
3151: where pcr.change_request_group_id=l_change_request_group_id

Line 3210: po_requisition_lines_all prl,

3206: prl.matching_basis,
3207: pcr.requester_id requester_id -- Bug # 3862383
3208: from po_change_requests pcr,
3209: po_line_locations_all pll,
3210: po_requisition_lines_all prl,
3211: po_headers_all poh,
3212: po_releases_all por,
3213: po_distributions_all pod,
3214: po_req_distributions_all prd,

Line 3766: FROM po_requisition_lines_all prl

3762: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
3763: WHERE h.REQUISITION_HEADER_ID = p_document_id
3764: AND NOT EXISTS
3765: (SELECT 'UNCANCELLED LINE EXISTS'
3766: FROM po_requisition_lines_all prl
3767: WHERE prl.requisition_header_id = p_document_id
3768: AND NVL(prl.cancel_flag,'N') = 'N'
3769: );
3770:

Line 4680: FROM po_requisition_lines_all

4676:
4677: -- get old req amount and amount dsp
4678: SELECT nvl(SUM(nvl(decode(matching_basis, 'AMOUNT', amount, quantity * unit_price), 0)), 0)
4679: into l_req_amount
4680: FROM po_requisition_lines_all
4681: WHERE requisition_header_id = l_req_header_id
4682: AND NVL(cancel_flag,'N') = 'N'
4683: AND NVL(modified_by_agent_flag, 'N') = 'N';
4684:

Line 4705: FROM po_requisition_lines_all rl,

4701: --Standard code
4702: -- get old tax and tax dsp
4703: SELECT nvl(sum(nonrecoverable_tax), 0)
4704: into l_tax_amount
4705: FROM po_requisition_lines_all rl,
4706: po_req_distributions_all rd
4707: WHERE rl.requisition_header_id = l_req_header_id
4708: AND rd.requisition_line_id = rl.requisition_line_id
4709: AND NVL(rl.cancel_flag,'N') = 'N'

Line 6466: from po_requisition_lines_all prl,

6462: nvl(sum(decode(pcr4.action_type, 'CANCELLATION', 0, decode(prl.matching_basis, 'AMOUNT', nvl(pcr3.new_amount, prl.amount),
6463: nvl(pcr1.new_price, prl.unit_price)*
6464: nvl(pcr2.new_quantity, prl.quantity)))), 0)
6465: into l_new_tax_amount, l_new_req_amount
6466: from po_requisition_lines_all prl,
6467: po_change_requests pcr1,
6468: po_change_requests pcr2,
6469: po_change_requests pcr3,
6470: po_change_requests pcr4

Line 6527: from po_requisition_lines_all prl,

6523: nvl(sum(decode(pcr1.action_type, 'CANCELLATION', 0,
6524: nvl(pcr1.new_price, prl.unit_price)*
6525: nvl(pcr2.new_quantity,prd.req_line_quantity))), 0)
6526: into l_new_tax_amount, l_new_req_amount
6527: from po_requisition_lines_all prl,
6528: po_req_distributions_all prd,
6529: po_change_requests pcr1,
6530: po_change_requests pcr2
6531: where prl.requisition_line_id=pcr1.document_line_id(+)

Line 8087: FROM po_requisition_lines_all rl,

8083: ELSE
8084: -- standard code
8085: SELECT nvl(sum(nvl(nonrecoverable_tax, 0)), 0)
8086: INTO l_new_tax_currency
8087: FROM po_requisition_lines_all rl,
8088: po_req_distributions_all rd
8089: WHERE rl.requisition_header_id = l_document_id
8090: AND rd.requisition_line_id = rl.requisition_line_id
8091: AND NVL(rl.modified_by_agent_flag, 'N') = 'N'

Line 8099: FROM po_requisition_lines_all

8095: -- Modified by Xiao and Eric for IL PO Notification on Feb-11,2009 , End
8096:
8097: SELECT nvl(SUM(nvl(decode(matching_basis, 'AMOUNT', amount, quantity * unit_price), 0)), 0)
8098: into l_new_amount_currency
8099: FROM po_requisition_lines_all
8100: WHERE requisition_header_id = l_document_id
8101: AND NVL(cancel_flag,'N') = 'N'
8102: AND NVL(modified_by_agent_flag, 'N') = 'N';
8103:

Line 8225: FROM po_requisition_lines_all

8221:
8222: -- get new req amount and req amount disp (at this moment, req has already been updated)
8223: SELECT nvl(SUM(nvl(decode(matching_basis, 'AMOUNT', amount, quantity * unit_price), 0)), 0)
8224: into l_req_amount
8225: FROM po_requisition_lines_all
8226: WHERE requisition_header_id = l_document_id
8227: AND NVL(cancel_flag,'N') = 'N'
8228: AND NVL(modified_by_agent_flag, 'N') = 'N';
8229:

Line 8249: FROM po_requisition_lines_all rl,

8245: ELSE
8246: --Standard Code
8247: SELECT nvl(sum(nonrecoverable_tax), 0)
8248: into l_tax_amount
8249: FROM po_requisition_lines_all rl,
8250: po_req_distributions_all rd
8251: WHERE rl.requisition_header_id = l_document_id
8252: AND rd.requisition_line_id = rl.requisition_line_id
8253: AND NVL(rl.cancel_flag,'N') = 'N'

Line 9115: update po_requisition_lines_all

9111:
9112: if(l_change_request_id is not null) then
9113: if(l_action_type='CANCELLATION') then
9114: -- accept the cancellation request
9115: update po_requisition_lines_all
9116: set cancel_flag='Y'
9117: where requisition_line_id=p_CanceledReqLineIDs_tbl(l_index);
9118: update po_change_requests
9119: set request_status='ACCEPTED',

Line 9132: FROM po_requisition_lines_all prl

9128: SET h.AUTHORIZATION_STATUS = 'CANCELLED'
9129: WHERE h.REQUISITION_HEADER_ID = l_document_id
9130: AND NOT EXISTS
9131: (SELECT 'UNCANCELLED LINE EXISTS'
9132: FROM po_requisition_lines_all prl
9133: WHERE prl.requisition_header_id = l_document_id
9134: AND NVL(prl.cancel_flag,'N') = 'N'
9135: );
9136:

Line 11992: po_requisition_lines_all prl

11988: pcr.old_need_by_date,
11989: pcr.new_need_by_date,
11990: pcr.action_type
11991: FROM po_change_requests pcr,
11992: po_requisition_lines_all prl
11993: WHERE pcr.change_request_group_id = l_change_request_group_id
11994: AND pcr.request_status = 'MGR_APP'
11995: AND pcr.document_line_id = prl.requisition_line_id
11996: ORDER BY prl.line_num;

Line 12005: po_requisition_lines_all prl

12001: CURSOR iso_change_csr_rejected(l_change_request_group_id IN NUMBER) IS
12002: SELECT prl.requisition_header_id,
12003: prl.requisition_line_id
12004: FROM po_change_requests pcr,
12005: po_requisition_lines_all prl
12006: WHERE pcr.change_request_group_id = l_change_request_group_id
12007: AND pcr.request_status = 'REJECTED'
12008: AND pcr.document_line_id = prl.requisition_line_id
12009: ORDER BY prl.line_num;

Line 12229: from po_requisition_lines_all

12225: l_progress := '002';
12226:
12227: select requisition_header_id
12228: into l_document_header_id
12229: from po_requisition_lines_all
12230: where requisition_line_id = p_document_line_id;
12231:
12232: --call OM API
12233: END IF;

Line 12507: po_requisition_lines_all prla

12503: prla.unit_price,
12504: prla.quantity
12505: FROM
12506: po_req_distributions_all prda,
12507: po_requisition_lines_all prla
12508: WHERE
12509: prla.requisition_line_id = req_line_id AND
12510: prla.requisition_line_id = prda.requisition_line_id;
12511:

Line 12542: po_requisition_lines_all prl

12538:
12539:
12540: select prh.preparer_id into l_preparer_id
12541: from po_requisition_headers_all prh,
12542: po_requisition_lines_all prl
12543: where prl.requisition_line_id = p_req_line_id
12544: and prl.requisition_header_id = prh.requisition_header_id;
12545:
12546: IF g_debug_stmt THEN

Line 12700: UPDATE po_requisition_lines_all

12696: IF g_debug_stmt THEN
12697: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');
12698: END IF;
12699:
12700: UPDATE po_requisition_lines_all
12701: SET quantity = quantity + p_delta_quantity
12702: WHERE requisition_line_id = p_req_line_id ;
12703:
12704: l_progress := '013';

Line 12780: UPDATE po_requisition_lines_all

12776: po_debug.debug_var(l_log_head,x_progress,'p_need_by_date', p_need_by_date );
12777: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12778: END IF;
12779:
12780: UPDATE po_requisition_lines_all
12781: SET need_by_date = p_need_by_date
12782: WHERE requisition_line_id = p_req_line_id ;
12783:
12784:

Line 12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;

12822: X_order_source_id NUMBER ; --12831835
12823: x_cancelled_quanity NUMBER; --12831835
12824:
12825: --14227140 changes starts
12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;

Line 12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;

12823: x_cancelled_quanity NUMBER; --12831835
12824:
12825: --14227140 changes starts
12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;
12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;

Line 12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;

12826: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;
12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
12832: --14227140 changes ends
12833: BEGIN
12834: x_progress := '001';

Line 12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;

12827: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
12828: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
12829: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
12830: l_sec_cancelled_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY_CANCELLED%TYPE;
12831: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
12832: --14227140 changes ends
12833: BEGIN
12834: x_progress := '001';
12835: IF g_debug_stmt THEN

Line 12837: po_debug.debug_stmt(l_log_head, x_progress,'Updating po_requisition_lines_all');

12833: BEGIN
12834: x_progress := '001';
12835: IF g_debug_stmt THEN
12836: po_debug.debug_var(l_log_head,x_progress,'p_req_line_id', p_req_line_id );
12837: po_debug.debug_stmt(l_log_head, x_progress,'Updating po_requisition_lines_all');
12838: END IF;
12839: --12831835 Begin Added the foll code to get the cancelled qty for update
12840: BEGIN
12841: select order_source_id

Line 12887: UPDATE po_requisition_lines_all

12883: IF( l_sec_uom_measure IS NULL) THEN
12884: SELECT unit_of_measure INTO l_sec_uom_measure FROM mtl_units_of_measure
12885: WHERE uom_code= l_sec_uom_code;
12886:
12887: UPDATE po_requisition_lines_all
12888: SET SECONDARY_UNIT_OF_MEASURE=l_sec_uom_measure
12889: WHERE requisition_line_id = p_req_line_id ;
12890: END IF;
12891: END IF;

Line 12925: UPDATE po_requisition_lines_all

12921: IF (l_is_req_encumbrance ) THEN
12922:
12923: --update po req lines as cancel flag I
12924: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
12925: UPDATE po_requisition_lines_all
12926: SET cancel_flag = 'I',
12927: LAST_UPDATED_BY = fnd_global.user_id,
12928: LAST_UPDATE_DATE = SYSDATE,
12929: cancel_date = SYSDATE

Line 12968: UPDATE po_requisition_lines_all prl

12964: --update po req lines as cancel flag I
12965: --12831835 Added updation of quantity_cancelled
12966: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
12967: -- bug 14227140 added SECONDARY_QUANTITY_CANCELLED column in update stmt
12968: UPDATE po_requisition_lines_all prl
12969: SET cancel_flag = 'Y',
12970: quantity_cancelled = x_cancelled_quanity,
12971: SECONDARY_QUANTITY_CANCELLED = l_sec_cancelled_qty,
12972: LAST_UPDATED_BY = fnd_global.user_id,

Line 12978: UPDATE po_requisition_lines_all prl

12974: cancel_date = SYSDATE
12975: WHERE requisition_line_id = p_req_line_id ;
12976: ELSE
12977: --update po req lines as cancel flag I
12978: UPDATE po_requisition_lines_all prl
12979: SET cancel_flag =null,
12980: -- quantity_cancelled = p_old_quantity,
12981: cancel_date =null
12982: WHERE requisition_line_id = p_req_line_id ;

Line 12997: UPDATE po_requisition_lines_all prl

12993:
12994: --update po req lines as cancel flag I
12995: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt
12996: -- bug 14227140 added SECONDARY_QUANTITY_CANCELLED column in update stmt
12997: UPDATE po_requisition_lines_all prl
12998: SET cancel_flag = 'Y',
12999: quantity_cancelled = x_cancelled_quanity,
13000: SECONDARY_QUANTITY_CANCELLED = l_sec_cancelled_qty,
13001: LAST_UPDATED_BY = fnd_global.user_id,

Line 13013: from po_requisition_lines_all

13009:
13010:
13011: --bug 7664476 -- roll up the authorization status if all lines of requisiton is cancelled
13012: Select REQUISITION_HEADER_ID into l_document_id
13013: from po_requisition_lines_all
13014: where requisition_line_id = p_req_line_id ;
13015:
13016: x_progress := '013';
13017: -- bug 14407998 changes added LAST_UPDATED_BY, LAST_UPDATE_DATE colums in update stmt

Line 13025: FROM po_requisition_lines_all prl

13021: h.LAST_UPDATE_DATE = SYSDATE
13022: WHERE h.REQUISITION_HEADER_ID = l_document_id
13023: AND NOT EXISTS
13024: (SELECT 'UNCANCELLED LINE EXISTS'
13025: FROM po_requisition_lines_all prl
13026: WHERE prl.requisition_header_id = l_document_id
13027: AND NVL(prl.cancel_flag,'N') = 'N'
13028: );
13029:

Line 13113: po_requisition_lines_all prl,

13109:
13110: SELECT mp.EMPLOYEE_ID
13111: into l_planner_id
13112: FROM po_change_requests pcr,
13113: po_requisition_lines_all prl,
13114: mtl_system_items_b mi,
13115: financials_system_params_all fsp,
13116: mtl_planners mp
13117: WHERE pcr.change_request_group_id =l_change_request_group_id

Line 13139: po_requisition_lines_all prl,

13135:
13136: l_sql := '
13137: SELECT mp.EMPLOYEE_ID
13138: FROM po_change_requests pcr,
13139: po_requisition_lines_all prl,
13140: mtl_system_items_b mi,
13141: financials_system_params_all fsp,
13142: mtl_planners mp
13143: WHERE pcr.change_request_group_id =:1

Line 13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;

13351: l_fc_result_status VARCHAR2(1);
13352: l_po_return_code VARCHAR2(100) := '';
13353: l_fc_out_tbl po_fcout_type;
13354: l_req_dist_id number;
13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;

Line 13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;

13352: l_po_return_code VARCHAR2(100) := '';
13353: l_fc_out_tbl po_fcout_type;
13354: l_req_dist_id number;
13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;

Line 13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;

13353: l_fc_out_tbl po_fcout_type;
13354: l_req_dist_id number;
13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;

Line 13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;

13354: l_req_dist_id number;
13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;

Line 13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;

13355: l_source_org PO_REQUISITION_LINES_ALL.SOURCE_ORGANIZATION_ID%TYPE;
13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
13363: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS

Line 13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;

13356: l_item_id PO_REQUISITION_LINES_ALL.ITEM_ID%TYPE;
13357: l_prim_qty PO_REQUISITION_LINES_ALL.QUANTITY%TYPE;
13358: l_sec_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13359: l_sec_new_qty PO_REQUISITION_LINES_ALL.SECONDARY_QUANTITY%TYPE;
13360: l_sec_uom_measure PO_REQUISITION_LINES_ALL.SECONDARY_UNIT_OF_MEASURE%TYPE;
13361: l_prim_uom_cde MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE%TYPE;
13362: l_sec_uom_code MTL_SYSTEM_ITEMS_B.SECONDARY_UOM_CODE%TYPE;
13363: CURSOR l_changed_req_dists_csr(req_line_id NUMBER) IS
13364: select DISTRIBUTION_ID

Line 13376: po_requisition_lines_all prla

13372: prla.unit_price,
13373: prla.quantity
13374: FROM
13375: po_req_distributions_all prda,
13376: po_requisition_lines_all prla
13377: WHERE
13378: prla.requisition_line_id = req_line_id AND
13379: prla.requisition_line_id = prda.requisition_line_id;
13380:

Line 13411: po_requisition_lines_all prl

13407:
13408:
13409: select prh.preparer_id into l_preparer_id
13410: from po_requisition_headers_all prh,
13411: po_requisition_lines_all prl
13412: where prl.requisition_line_id = p_req_line_id
13413: and prl.requisition_header_id = prh.requisition_header_id;
13414:
13415: IF g_debug_stmt THEN

Line 13564: FROM po_requisition_lines_all

13560:
13561: l_progress := '012';
13562: SELECT SOURCE_ORGANIZATION_ID, ITEM_ID, QUANTITY, SECONDARY_QUANTITY
13563: INTO l_source_org, l_item_id, l_prim_qty, l_sec_qty
13564: FROM po_requisition_lines_all
13565: WHERE requisition_line_id = p_req_line_id ;
13566:
13567: IF (p_delta_sec_quantity IS NOT NULL AND l_sec_qty IS NOT NULL ) THEN
13568: UPDATE po_requisition_lines_all

Line 13568: UPDATE po_requisition_lines_all

13564: FROM po_requisition_lines_all
13565: WHERE requisition_line_id = p_req_line_id ;
13566:
13567: IF (p_delta_sec_quantity IS NOT NULL AND l_sec_qty IS NOT NULL ) THEN
13568: UPDATE po_requisition_lines_all
13569: SET secondary_quantity = secondary_quantity + p_delta_sec_quantity
13570: WHERE requisition_line_id = p_req_line_id ;
13571:
13572: ELSE

Line 13596: UPDATE po_requisition_lines_all

13592: WHERE uom_code= l_sec_uom_code;
13593:
13594: IF( p_delta_sec_quantity IS NULL) THEN
13595: IF( l_sec_qty IS NULL) THEN
13596: UPDATE po_requisition_lines_all
13597: SET SECONDARY_UNIT_OF_MEASURE=l_sec_uom_measure, secondary_quantity = l_sec_new_qty
13598: WHERE requisition_line_id = p_req_line_id ;
13599: END IF;
13600: ELSE

Line 13601: UPDATE po_requisition_lines_all

13597: SET SECONDARY_UNIT_OF_MEASURE=l_sec_uom_measure, secondary_quantity = l_sec_new_qty
13598: WHERE requisition_line_id = p_req_line_id ;
13599: END IF;
13600: ELSE
13601: UPDATE po_requisition_lines_all
13602: SET SECONDARY_UNIT_OF_MEASURE=l_sec_uom_measure, secondary_quantity = l_sec_new_qty + p_delta_sec_quantity
13603: WHERE requisition_line_id = p_req_line_id ;
13604: END IF;
13605: END IF;

Line 13616: UPDATE po_requisition_lines_all

13612: po_debug.debug_STmt(l_log_head, l_progress, 'Updating the req line and dist with the quantity changes');
13613: END IF;
13614:
13615: IF (p_delta_prim_quantity IS NOT NULL ) THEN
13616: UPDATE po_requisition_lines_all
13617: SET quantity = quantity + p_delta_prim_quantity
13618: WHERE requisition_line_id = p_req_line_id ;
13619:
13620: l_progress := '017';

Line 13685: SELECT REQUISITION_LINE_ID INTO l_line_id FROM po_requisition_lines_all WHERE LINE_LOCATION_ID = l_line_loc_id;

13681: BEGIN
13682: SELECT DOCUMENT_LINE_LOCATION_ID INTO l_line_loc_id FROM po_change_requests WHERE CHANGE_REQUEST_ID = l_change_request_id ;
13683:
13684: IF(l_line_loc_id IS NOT NULL) THEN
13685: SELECT REQUISITION_LINE_ID INTO l_line_id FROM po_requisition_lines_all WHERE LINE_LOCATION_ID = l_line_loc_id;
13686: RETURN l_line_id;
13687: ELSE
13688: SELECT DOCUMENT_LINE_ID INTO l_line_id FROM po_change_requests WHERE CHANGE_REQUEST_ID
13689: = (SELECT PARENT_CHANGE_REQUEST_ID FROM po_change_requests WHERE CHANGE_REQUEST_ID= l_change_request_id);