APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_LINE_LOCATIONS

Line 27: ( p_po_line_id IN PO_LINE_LOCATIONS.po_line_id%TYPE

23:
24: PROCEDURE delete_price_breaks (x_po_header_id NUMBER, x_po_line_id NUMBER);
25:
26: PROCEDURE update_price_discount -- <2703076>
27: ( p_po_line_id IN PO_LINE_LOCATIONS.po_line_id%TYPE
28: , p_unit_price IN PO_LINES.unit_price%TYPE
29: );
30:
31: /*===========================================================================*/

Line 250: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE; --< Shared Proc FPJ >

246: /* Bug 2722795 */
247: l_retroactive_date po_lines.retroactive_date%type := null;
248: l_price_break_lookup_code po_lines.price_break_lookup_code%type;
249: l_transaction_flow_header_id
250: PO_LINE_LOCATIONS_ALL.transaction_flow_header_id%TYPE; --< Shared Proc FPJ >
251: l_uom_valid boolean := TRUE; -- bug 3335027
252: l_uom_different boolean := FALSE; -- bug 3335027
253: l_update_exp_date boolean := FALSE; -- bug 3335027
254: l_conv_price number;

Line 274: -- If X_create_po_line_loc_flag is 'Y' then create a price break in po_line_locations.

270:
271: x_line_updated_flag := 'N';
272:
273: -- If X_update_po_line_flag is 'Y' then update corresponding line in po_lines.
274: -- If X_create_po_line_loc_flag is 'Y' then create a price break in po_line_locations.
275:
276: X_progress := '010';
277:
278:

Line 728: from po_line_locations_all

724: -- Insert the warning only if price breaks exist
725: Begin
726: select count(*)
727: into l_price_break_ct
728: from po_line_locations_all
729: where po_line_id = x_po_line_id
730: and shipment_type = 'PRICE BREAK';
731: Exception
732: When others then

Line 861: -- Line is a price break line if X_create_po_line_loc_flag = 'Y' - insert in po_line_locations.

857: END IF; --IF ((X_update_po_line_flag = 'Y')...
858: --
859:
860: --
861: -- Line is a price break line if X_create_po_line_loc_flag = 'Y' - insert in po_line_locations.
862: --
863:
864: IF (X_create_po_line_loc_flag = 'Y') AND
865: (X_header_processable_flag = 'Y') AND

Line 903: FROM po_line_locations

899:
900: IF (X_shipment_num IS NULL ) THEN
901: SELECT NVL(MAX(shipment_num),0) +1
902: INTO X_shipment_num
903: FROM po_line_locations
904: WHERE po_header_id = X_po_header_id
905: AND po_line_id = X_po_line_id
906: --Bug# 1549896
907: --togeorge 01/29/2001

Line 922: SELECT po_line_locations_s.nextval

918: */
919:
920:
921:
922: SELECT po_line_locations_s.nextval
923: INTO X_line_location_id
924: FROM dual;
925:
926:

Line 928: po_line_locations_sv7.validate_po_line_coordination(

924: FROM dual;
925:
926:
927: /* Bug 2845962. Added a new parameter, X_line_num. */
928: po_line_locations_sv7.validate_po_line_coordination(
929: X_interface_header_id,
930: X_interface_line_id,
931: X_item_id,
932: X_item_description,

Line 955: po_line_locations_sv7.validate_po_line_locations(

951: --
952: -- DO WE perform a complete validation. YES as we are creating a new line
953: --
954:
955: po_line_locations_sv7.validate_po_line_locations(
956: X_interface_header_id,
957: X_interface_line_id,
958: X_line_location_id,
959: X_last_update_date,

Line 1091: FROM po_line_locations pll,

1087:
1088: BEGIN
1089: SELECT NVL(MAX(pll.shipment_num),0) + 1
1090: INTO X_shipment_num
1091: FROM po_line_locations pll,
1092: po_headers_all poh
1093: WHERE pll.po_header_id = X_po_header_id
1094: AND pll.po_line_id = X_po_line_id
1095: AND poh.po_header_id = pll.po_header_id

Line 1114: po_line_locations_sv6.insert_po_line_locations(

1110: 'NON CUMULATIVE')) THEN
1111: po_lines_sv2.retroactive_change(X_po_Line_id);
1112: END IF;
1113:
1114: po_line_locations_sv6.insert_po_line_locations(
1115: X_line_location_id,
1116: X_last_update_date,
1117: X_last_updated_by,
1118: X_current_po_header_id,

Line 1746: FROM po_line_locations

1742: IS
1743:
1744: Cursor C_line_locations Is
1745: SELECT line_location_id
1746: FROM po_line_locations
1747: WHERE po_line_id = x_po_line_id
1748: AND po_header_id = x_po_header_id;
1749:
1750: x_line_location_id NUMBER;

Line 1767: DELETE FROM PO_LINE_LOCATIONS

1763: -- Bug: 1588445 While deleting price breaks take into consideration shipment
1764: -- type QUOTATION also. Otherwise for shipment type quotation it does not
1765: -- delete the old price breaks.
1766:
1767: DELETE FROM PO_LINE_LOCATIONS
1768: WHERE PO_LINE_ID = X_po_line_id
1769: AND PO_HEADER_ID = X_po_header_id
1770: AND SHIPMENT_TYPE in ('PRICE BREAK','QUOTATION');
1771:

Line 1785: p_po_line_id IN PO_LINE_LOCATIONS.po_line_id%TYPE,

1781:
1782: =============================================================================*/
1783: PROCEDURE update_price_discount
1784: (
1785: p_po_line_id IN PO_LINE_LOCATIONS.po_line_id%TYPE,
1786: p_unit_price IN PO_LINES.unit_price%TYPE
1787: )
1788: IS BEGIN
1789:

Line 1790: UPDATE PO_LINE_LOCATIONS

1786: p_unit_price IN PO_LINES.unit_price%TYPE
1787: )
1788: IS BEGIN
1789:
1790: UPDATE PO_LINE_LOCATIONS
1791: SET price_discount = round(((p_unit_price - price_override)/p_unit_price * 100), 2)
1792: WHERE po_line_id = p_po_line_id;
1793:
1794: EXCEPTION