DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_LINES_S

Line 2724: x_secondary_qty po_lines.secondary_quantity%type := NULL;

2720: -- bug# 3345108
2721: -- comment out most of the changes done by bug 2219743.
2722: -- bug# 2219743
2723: /**
2724: x_secondary_qty po_lines.secondary_quantity%type := NULL;
2725: x_item_number VARCHAR2(240);
2726: x_process_org VARCHAR2(1);
2727: x_dummy VARCHAR2(240);
2728: x_product VARCHAR2(3) := 'GMI';

Line 2805: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;

2801:
2802: --
2803: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2804: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
2805: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
2806: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
2807: l_quantity_temp PO_LINES.QUANTITY%TYPE;
2808: --
2809:

Line 3687: SELECT po_lines_s.nextval

3683:
3684:
3685: l_progress:='330';
3686:
3687: SELECT po_lines_s.nextval
3688: INTO x_po_line_id
3689: FROM sys.dual;
3690:
3691: l_progress:='340';

Line 4642: /** If FSP org and item combination is dual uom control, update the po lines secondary quantity

4638: -- because x_po_line_id is the blanket line_id for 'Release'
4639: -- Introducing the 'If' statement for checking that its not a release
4640: IF (g_document_subtype <> 'RELEASE') THEN
4641:
4642: /** If FSP org and item combination is dual uom control, update the po lines secondary quantity
4643: with the default conversion based on the PO lines quantity **/
4644:
4645: -- update secondary quantity/uom to null
4646:

Line 5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;

5293:
5294: --
5295: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5296: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5297: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5298: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5299: --
5300:
5301: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --