DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on PO_LINES_S

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

3057: -- bug# 3345108
3058: -- comment out most of the changes done by bug 2219743.
3059: -- bug# 2219743
3060: /**
3061: x_secondary_qty po_lines.secondary_quantity%type := NULL;
3062: x_item_number VARCHAR2(240);
3063: x_process_org VARCHAR2(1);
3064: x_dummy VARCHAR2(240);
3065: x_product VARCHAR2(3) := 'GMI';

Line 3142: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;

3138:
3139: --
3140: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3141: x_secondary_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
3142: x_secondary_quantity_def PO_LINES.SECONDARY_QUANTITY%TYPE;
3143: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
3144: l_quantity_temp PO_LINES.QUANTITY%TYPE;
3145: --
3146:

Line 4053: SELECT po_lines_s.nextval

4049:
4050:
4051: l_progress:='330';
4052:
4053: SELECT po_lines_s.nextval
4054: INTO x_po_line_id
4055: FROM sys.dual;
4056:
4057: l_progress:='340';

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

5070: -- because x_po_line_id is the blanket line_id for 'Release'
5071: -- Introducing the 'If' statement for checking that its not a release
5072: IF (g_document_subtype <> 'RELEASE') THEN
5073:
5074: /** If FSP org and item combination is dual uom control, update the po lines secondary quantity
5075: with the default conversion based on the PO lines quantity **/
5076:
5077: -- update secondary quantity/uom to null
5078:

Line 5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;

5756:
5757: --
5758: x_shipment_uom MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5759: x_secondary_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;
5760: x_secondary_quantity PO_LINES.SECONDARY_QUANTITY%TYPE;
5761: x_secondary_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
5762: --
5763:
5764: l_matching_basis PO_LINE_TYPES.matching_basis%TYPE; --