APPS.PON_CONTERMS_UTL_PVT dependencies on PON_BID_HEADERS

Line 50: from pon_bid_headers

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

Line 317: from pon_bid_headers

313: l_bus_doc_type := get_response_doc_type(l_doc_type_id);
314:
315: select bid_status
316: into l_new_bid_status
317: from pon_bid_headers
318: where bid_number = p_new_bid_number;
319:
320: if (p_old_bid_number <>-1) then
321: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;

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

317: from pon_bid_headers
318: where bid_number = p_new_bid_number;
319:
320: if (p_old_bid_number <>-1) then
321: select bid_status into l_old_bid_status from pon_bid_headers where bid_number = p_old_bid_number;
322: end if;
323:
324: if (is_contracts_installed() = FND_API.G_TRUE) then
325:

Line 519: FROM pon_bid_headers

515: */
516:
517: CURSOR active_bids IS
518: SELECT bid_number
519: FROM pon_bid_headers
520: WHERE auction_header_id in (select a.auction_header_id
521: from pon_auction_headers_all a,
522: pon_auction_headers_all b
523: where b.auction_header_id = p_auction_header_id

Line 722: FROM pon_bid_headers

718: l_org_id NUMBER;
719:
720: CURSOR active_bids IS
721: SELECT bid_number
722: FROM pon_bid_headers
723: WHERE auction_header_id = p_auction_header_id
724: and bid_status = 'ACTIVE';
725: BEGIN
726: x_doctype_id :=p_doc_type_id;

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

1070: l_internal_contact_id Number := null; --
1071: l_internal_contact_pid Number :=null;
1072: l_contractualonly Varchar2(1) := 'N';
1073:
1074: l_external_party_id Number := null; -- pon_bid_headers.trading_partner_id
1075: l_external_contact_id Number := null; -- pon_bid_headers.trading_partner_contact_id
1076:
1077: l_copy_deliverables Varchar2(1) := 'Y';
1078:

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

1071: l_internal_contact_pid Number :=null;
1072: l_contractualonly Varchar2(1) := 'N';
1073:
1074: l_external_party_id Number := null; -- pon_bid_headers.trading_partner_id
1075: l_external_contact_id Number := null; -- pon_bid_headers.trading_partner_contact_id
1076:
1077: l_copy_deliverables Varchar2(1) := 'Y';
1078:
1079: l_document_number Varchar2(250) := null;

Line 1105: pon_bid_headers b

1101: --
1102: select h.org_id
1103: into l_org_id
1104: from pon_auction_headers_all h,
1105: pon_bid_headers b
1106: where b.bid_number = p_source_bid_number
1107: and h.auction_header_id = b.auction_header_id;
1108:
1109: --

Line 1211: from pon_bid_headers b,

1207: select b.doctype_id ,
1208: a.org_id
1209: into l_doc_type_id,
1210: l_org_id
1211: from pon_bid_headers b,
1212: pon_auction_headers_all a
1213: where b.bid_number = p_bid_number
1214: and a.auction_header_id = b.auction_header_id;
1215:

Line 1311: FROM pon_bid_headers

1307: l_api_name CONSTANT VARCHAR2(30) :='disableDeliverables';
1308:
1309: CURSOR active_bids IS
1310: SELECT bid_number
1311: FROM pon_bid_headers
1312: WHERE auction_header_id =p_auction_number
1313: and bid_status = 'ACTIVE';
1314:
1315: BEGIN