DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUC_HEADERS_INTERFACE

Line 1290: --Populate PON_AUC_HEADERS_INTERFACE table

1286:
1287: --Bug 2694722 : Getting user id
1288: l_user_id := FND_GLOBAL.USER_ID;
1289:
1290: --Populate PON_AUC_HEADERS_INTERFACE table
1291: insert into pon_auc_headers_interface(
1292: interface_auction_header_id,
1293: neg_type,
1294: contract_type,

Line 1291: insert into pon_auc_headers_interface(

1287: --Bug 2694722 : Getting user id
1288: l_user_id := FND_GLOBAL.USER_ID;
1289:
1290: --Populate PON_AUC_HEADERS_INTERFACE table
1291: insert into pon_auc_headers_interface(
1292: interface_auction_header_id,
1293: neg_type,
1294: contract_type,
1295: ship_to_location_id,

Line 1326: select PON_AUC_HEADERS_INTERFACE_S.nextval,

1322: source_doc_msg_app,
1323: po_style_id, -- BUG#5532470
1324: language_code, --Bug#4911361
1325: supplier_site_id)
1326: select PON_AUC_HEADERS_INTERFACE_S.nextval,
1327: p_negotiation_type,
1328: 'BLANKET',
1329: ship_to_location_id,
1330: bill_to_location_id,

Line 1371: select PON_AUC_HEADERS_INTERFACE_S.currval

1367:
1368: l_progress := '002';
1369:
1370: -- Get the interface_id into local variable
1371: select PON_AUC_HEADERS_INTERFACE_S.currval
1372: into l_interface_id
1373: from dual;
1374:
1375: l_progress := '003';