APPS.PON_CONTERMS_UTL_PVT dependencies on PON_BID_HEADERS

Line 48: from pon_bid_headers

44: p_contracts_doctype = RESPONSE) then
45: begin
46: select auction_header_id
47: into x_auction_header_id
48: from pon_bid_headers
49: where bid_number = p_contracts_doc_id;
50:
51: x_return_status := fnd_api.g_ret_sts_success;
52: exception

Line 311: from pon_bid_headers

307: l_bus_doc_type := get_response_doc_type(l_doc_type_id);
308:
309: select bid_status
310: into l_new_bid_status
311: from pon_bid_headers
312: where bid_number = p_new_bid_number;
313:
314: if (p_old_bid_number <>-1) then
315: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;

Line 315: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;

311: from pon_bid_headers
312: where bid_number = p_new_bid_number;
313:
314: if (p_old_bid_number <>-1) then
315: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;
316: end if;
317:
318: if (is_contracts_installed() = FND_API.G_TRUE) then
319:

Line 513: FROM pon_bid_headers

509: */
510:
511: CURSOR active_bids IS
512: SELECT bid_number
513: FROM pon_bid_headers
514: WHERE auction_header_id in (select a.auction_header_id
515: from pon_auction_headers_all a,
516: pon_auction_headers_all b
517: where b.auction_header_id = p_auction_header_id

Line 716: FROM pon_bid_headers

712: l_org_id NUMBER;
713:
714: CURSOR active_bids IS
715: SELECT bid_number
716: FROM pon_bid_headers
717: WHERE auction_header_id = p_auction_header_id
718: and bid_status = 'ACTIVE';
719: BEGIN
720: x_doctype_id :=p_doc_type_id;

Line 1068: l_external_party_id Number := null; -- pon_bid_headers.trading_partner_id

1064: l_internal_contact_id Number := null; --
1065: l_internal_contact_pid Number :=null;
1066: l_contractualonly Varchar2(1) := 'N';
1067:
1068: l_external_party_id Number := null; -- pon_bid_headers.trading_partner_id
1069: l_external_contact_id Number := null; -- pon_bid_headers.trading_partner_contact_id
1070:
1071: l_copy_deliverables Varchar2(1) := 'Y';
1072:

Line 1069: l_external_contact_id Number := null; -- pon_bid_headers.trading_partner_contact_id

1065: l_internal_contact_pid Number :=null;
1066: l_contractualonly Varchar2(1) := 'N';
1067:
1068: l_external_party_id Number := null; -- pon_bid_headers.trading_partner_id
1069: l_external_contact_id Number := null; -- pon_bid_headers.trading_partner_contact_id
1070:
1071: l_copy_deliverables Varchar2(1) := 'Y';
1072:
1073: l_document_number Varchar2(250) := null;

Line 1099: pon_bid_headers b

1095: --
1096: select h.org_id
1097: into l_org_id
1098: from pon_auction_headers_all h,
1099: pon_bid_headers b
1100: where b.bid_number = p_source_bid_number
1101: and h.auction_header_id = b.auction_header_id;
1102:
1103: --

Line 1205: from pon_bid_headers b,

1201: select b.doctype_id ,
1202: a.org_id
1203: into l_doc_type_id,
1204: l_org_id
1205: from pon_bid_headers b,
1206: pon_auction_headers_all a
1207: where b.bid_number = p_bid_number
1208: and a.auction_header_id = b.auction_header_id;
1209:

Line 1305: FROM pon_bid_headers

1301: l_api_name CONSTANT VARCHAR2(30) :='disableDeliverables';
1302:
1303: CURSOR active_bids IS
1304: SELECT bid_number
1305: FROM pon_bid_headers
1306: WHERE auction_header_id =p_auction_number
1307: and bid_status = 'ACTIVE';
1308:
1309: BEGIN