[Home] [Help]
1740: po_headers_interface_s.NEXTVAL
1741: INTO
1742: l_interface_header_id
1743: FROM
1744: DUAL;
1745:
1746: l_transaction_date := l_global_rate_date;
1747:
1748: IF (l_valid_flag = 'G') AND (NVL(l_global_rate,-1) = -1)
2031: l_conv_qty := l_quantity;
2032: END IF;
2033:
2034: -- INVCONV retrive secondary unit of measure for the item
2035: -- if its not null that means item is tracked in dual units
2036: -- from the quantity
2037: IF l_secondary_quantity IS NOT NULL THEN
2038: OPEN cr_get_sec_uom;
2039: FETCH cr_get_sec_uom INTO l_secondary_uom;
2149: END IF;
2150:
2151: SELECT PO_LINES_INTERFACE_S.NEXTVAL
2152: INTO l_interface_line_id
2153: FROM DUAL;
2154:
2155: /* Bug 7231720 If the Profile Option PO: Automatic Document Sourcing is set to "Yes" then
2156: the latest valid blanket must be picked even if the blanket is not present in the Approved
2157: Supplier List. There is no check for the presence of a record in the table po_asl_documents if
2334: SELECT
2335: PO_DISTRIBUTIONS_INTERFACE_S.NEXTVAL
2336: INTO
2337: l_dist_interface_header_id
2338: FROM DUAL;
2339:
2340: IF (l_debug = 1)
2341: THEN
2342: INV_LOG_UTIL.trace
2398: ,DECODE(l_rate,-1,NULL,l_date))
2399: /* Bug fix 5373370 - new column addded to po_dist_interface - Start*/
2400: , TO_CHAR(l_dist_interface_header_id)
2401: /* Bug fix 5373370 - End */
2402: FROM DUAL;
2403:
2404:
2405: /* Bug 5373370 - Start */
2406: /* The distribution_interface_ref that is inserted into
3867: -- Generate sequence that will become the new batch id
3868:
3869: SELECT mtl_third_party_cp_s.NEXTVAL
3870: INTO l_batch_id
3871: FROM dual;
3872:
3873: RETURN l_batch_id;
3874:
3875: IF (l_debug = 1)