[Home] [Help]
1828:
1829: --Bug 2694722 : Getting user id
1830: l_user_id := FND_GLOBAL.USER_ID;
1831:
1832: --Populate PON_AUC_HEADERS_INTERFACE table
1833: insert into pon_auc_headers_interface(
1834: interface_auction_header_id,
1835: neg_type,
1836: contract_type,
1829: --Bug 2694722 : Getting user id
1830: l_user_id := FND_GLOBAL.USER_ID;
1831:
1832: --Populate PON_AUC_HEADERS_INTERFACE table
1833: insert into pon_auc_headers_interface(
1834: interface_auction_header_id,
1835: neg_type,
1836: contract_type,
1837: ship_to_location_id,
1864: source_doc_msg_app,
1865: po_style_id, -- BUG#5532470
1866: language_code, --Bug#4911361
1867: supplier_site_id)
1868: select PON_AUC_HEADERS_INTERFACE_S.nextval,
1869: p_negotiation_type,
1870: 'BLANKET',
1871: ship_to_location_id,
1872: bill_to_location_id,
1909:
1910: l_progress := '002';
1911:
1912: -- Get the interface_id into local variable
1913: select PON_AUC_HEADERS_INTERFACE_S.currval
1914: into l_interface_id
1915: from dual;
1916:
1917: l_progress := '003';