APPS.PO_NEGOTIATIONS_SV1 dependencies on PON_AUCTION_HEADERS_ALL

Line 371: x_document_number pon_auction_headers_all.document_number%TYPE;

367: --
368: l_return_status VARCHAR2(1);
369: l_msg_count NUMBER;
370: l_msg_data VARCHAR2(2000);
371: x_document_number pon_auction_headers_all.document_number%TYPE;
372: --
373:
374: /* --
375: l_req_line_id_table PO_DOC_STYLE_PVT.g_po_tbl_num;

Line 1158: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=x_negotiation_id;

1154: where requisition_line_id = x_req_line_id ; --5841426
1155:
1156: -- bug# 9887326
1157: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(x_negotiation_id) = 1 ) THEN
1158: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=x_negotiation_id;
1159: update po_requisition_lines_all
1160: SET auction_display_number = x_document_number
1161: where requisition_line_id = x_req_line_id ;
1162: END IF;

Line 2503: x_document_number pon_auction_headers_all.document_number%TYPE;

2499:
2500: --
2501: l_line_uda_temp_id NUMBER;
2502: l_contract_type VARCHAR2(40);
2503: x_document_number pon_auction_headers_all.document_number%TYPE;
2504:
2505: BEGIN
2506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.string(fnd_log.level_statement,g_log_head,'Procedure add_line_to_negotiation1 Start ');

Line 2515: select org_id into x_org_id from pon_auction_headers_all where auction_header_id = p_auction_header_id;

2511:
2512: /* get the current org_id from auction header*/
2513: x_progress := '000';
2514: x_grouping_method := 'REQUISITION';
2515: select org_id into x_org_id from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2516:
2517: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2518: fnd_log.string(fnd_log.level_statement,g_log_head,'x_grouping_method : '||x_grouping_method);
2519: fnd_log.string(fnd_log.level_statement,g_log_head,'x_org_id : '||x_org_id);

Line 2528: select contract_type into l_contract_type from pon_auction_headers_all where auction_header_id = p_auction_header_id;

2524:
2525: SAVEPOINT CHECK_LOCK;
2526:
2527: --Get Uda Template Id and Contract Type from exisiting Auction
2528: select contract_type into l_contract_type from pon_auction_headers_all where auction_header_id = p_auction_header_id;
2529: l_line_uda_temp_id := NULL;
2530:
2531: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2532: fnd_log.string(fnd_log.level_statement,g_log_head,'l_contract_type : '||l_contract_type);

Line 3006: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=p_auction_header_id;

3002: where requisition_line_id = x_req_line_id ;
3003:
3004: -- bug# 9887326
3005: IF ( PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id) = 1 ) THEN
3006: SELECT document_number INTO x_document_number FROM pon_auction_headers_all WHERE auction_header_id=p_auction_header_id;
3007: update po_requisition_lines_all
3008: SET auction_display_number = x_document_number
3009: where requisition_line_id = x_req_line_id ;
3010: END IF;

Line 3223: SELECT uda_template_id INTO l_sol_uda_temp_id FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;

3219: END LOOP;
3220:
3221: BEGIN
3222: SELECT requisition_header_id INTO l_req_header_id FROM po_requisition_lines_all WHERE requisition_line_id = l_req_line_id;
3223: SELECT uda_template_id INTO l_sol_uda_temp_id FROM pon_auction_headers_all WHERE auction_header_id = p_auction_header_id;
3224: SELECT uda_template_id INTO l_req_uda_temp_id FROM po_requisition_headers_all WHERE REQUISITION_HEADER_ID= l_req_header_id;
3225:
3226: EXCEPTION WHEN OTHERS THEN
3227: l_req_header_id := NULL;