[Home] [Help]
177: )
178: IS
179: l_api_name CONSTANT VARCHAR2(100) := 'create_update_delrec';
180: l_api_version CONSTANT NUMBER := 1.0;
181: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
182:
183: -- define record of tables for bulk processing
184: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
185: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;
296:
297: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN
298: SELECT shipping_control
299: INTO l_shipping_control
300: FROM PO_HEADERS_ALL
301: WHERE po_header_id = p_doc_id;
302: ELSIF ( p_doc_type = 'RELEASE' AND p_doc_subtype = 'BLANKET') THEN
303: SELECT shipping_control
304: INTO l_shipping_control
866: x_fte_rec.rcv_supplier_item_num,
867: x_fte_rec.rcv_preferred_grade,
868: x_fte_rec.asn_type
869: FROM
870: po_headers_all poh,
871: po_lines_all pol,
872: po_line_locations_all pll,
873: rcv_transactions rt,
874: mtl_system_items msi,
1161: x_fte_rec.rcv_supplier_item_num,
1162: x_fte_rec.rcv_preferred_grade,
1163: x_fte_rec.asn_type
1164: FROM
1165: po_headers_all poh,
1166: po_lines_all pol,
1167: po_line_locations_all pll,
1168: rcv_transactions rt,
1169: mtl_system_items msi,
1429: x_fte_rec.net_weight,
1430: x_fte_rec.weight_uom_code,
1431: x_fte_rec.volume,
1432: x_fte_rec.volume_uom_code
1433: FROM PO_HEADERS POH,
1434: PO_LINES POL,
1435: PO_LINE_LOCATIONS POLL,
1436: PO_LINE_TYPES_B PLT,
1437: ORG_FREIGHT_TL FRT,
1651: x_fte_rec.net_weight,
1652: x_fte_rec.weight_uom_code,
1653: x_fte_rec.volume,
1654: x_fte_rec.volume_uom_code
1655: FROM PO_HEADERS POH,
1656: PO_LINES POL,
1657: PO_LINE_LOCATIONS POLL,
1658: PO_LINE_TYPES_B PLT,
1659: ORG_FREIGHT_TL FRT,
1872: x_fte_rec.net_weight,
1873: x_fte_rec.weight_uom_code,
1874: x_fte_rec.volume,
1875: x_fte_rec.volume_uom_code
1876: FROM PO_HEADERS POH,
1877: PO_LINES POL,
1878: PO_LINE_LOCATIONS POLL,
1879: PO_LINE_TYPES_B PLT,
1880: ORG_FREIGHT_TL FRT,
2094: x_fte_rec.net_weight,
2095: x_fte_rec.weight_uom_code,
2096: x_fte_rec.volume,
2097: x_fte_rec.volume_uom_code
2098: FROM PO_HEADERS POH,
2099: PO_LINES POL,
2100: PO_LINE_LOCATIONS POLL,
2101: PO_LINE_TYPES_B PLT,
2102: ORG_FREIGHT_TL FRT,
2316: x_fte_rec.net_weight,
2317: x_fte_rec.weight_uom_code,
2318: x_fte_rec.volume,
2319: x_fte_rec.volume_uom_code
2320: FROM PO_HEADERS POH,
2321: PO_LINES POL,
2322: PO_LINE_LOCATIONS POLL,
2323: PO_LINE_TYPES_B PLT,
2324: ORG_FREIGHT_TL FRT,
2541: x_fte_rec.weight_uom_code,
2542: x_fte_rec.volume,
2543: x_fte_rec.volume_uom_code
2544: FROM PO_RELEASES POR,
2545: PO_HEADERS POH,
2546: PO_LINES POL,
2547: PO_LINE_LOCATIONS POLL,
2548: PO_LINE_TYPES_B PLT,
2549: ORG_FREIGHT_TL FRT,
2769: x_fte_rec.weight_uom_code,
2770: x_fte_rec.volume,
2771: x_fte_rec.volume_uom_code
2772: FROM PO_RELEASES POR,
2773: PO_HEADERS POH,
2774: PO_LINES POL,
2775: PO_LINE_LOCATIONS POLL,
2776: PO_LINE_TYPES_B PLT,
2777: ORG_FREIGHT_TL FRT,
2995: x_fte_rec.weight_uom_code,
2996: x_fte_rec.volume,
2997: x_fte_rec.volume_uom_code
2998: FROM PO_RELEASES POR,
2999: PO_HEADERS POH,
3000: PO_LINES POL,
3001: PO_LINE_LOCATIONS POLL,
3002: PO_LINE_TYPES_B PLT,
3003: ORG_FREIGHT_TL FRT,
3222: x_fte_rec.weight_uom_code,
3223: x_fte_rec.volume,
3224: x_fte_rec.volume_uom_code
3225: FROM PO_RELEASES POR,
3226: PO_HEADERS POH,
3227: PO_LINES POL,
3228: PO_LINE_LOCATIONS POLL,
3229: PO_LINE_TYPES_B PLT,
3230: ORG_FREIGHT_TL FRT,
3451: x_fte_rec.weight_uom_code,
3452: x_fte_rec.volume,
3453: x_fte_rec.volume_uom_code
3454: FROM PO_RELEASES POR,
3455: PO_HEADERS POH,
3456: PO_LINES POL,
3457: PO_LINE_LOCATIONS POLL,
3458: PO_LINE_TYPES_B PLT,
3459: ORG_FREIGHT_TL FRT,