DBA Data[Home] [Help]

APPS.PON_SOURCING_OPENAPI_GRP dependencies on PON_AUCTION_HEADERS_ALL_S

Line 286: l_standard_form pon_auction_headers_all.standard_form%TYPE;

282: l_return_status VARCHAR2(1);
283: --
284:
285: --Bug : 16690156
286: l_standard_form pon_auction_headers_all.standard_form%TYPE;
287: l_document_format pon_auction_headers_all.document_format%TYPE;
288:
289:
290: BEGIN

Line 496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number

492: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
493: 'Getting the document_number from sequence');
494: end if;
495:
496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number
497: FROM dual;
498:
499: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
500: fnd_log.string(fnd_log.level_statement,

Line 2224: update pon_auction_headers_all set

2220: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',
2221: 'Concurrent request successfully raised; Request id : ' || l_request_id ||' ; setting the request information into pon_auction_headers_all');
2222: end if;
2223:
2224: update pon_auction_headers_all set
2225: request_id = l_request_id,
2226: number_of_lines = 0,
2227: requested_by = g_header_rec.user_id ,
2228: request_date = sysdate,