eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PON_CONTERMS_UTL_PVT dependencies on PON_AUCTION_HEADERS_ALL

Line 31: x_auction_header_id OUT NOCOPY pon_auction_headers_all.auction_header_id%type,

27:
28: PROCEDURE get_auction_header_id(
29: p_contracts_doctype IN VARCHAR2,
30: p_contracts_doc_id IN NUMBER,
31: x_auction_header_id OUT NOCOPY pon_auction_headers_all.auction_header_id%type,
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_data OUT NOCOPY VARCHAR2,
34: x_msg_count OUT NOCOPY NUMBER
35: ) IS

Line 141: from pon_auction_headers_all

137: BEGIN
138:
139: select org_id
140: into l_org_id
141: from pon_auction_headers_all
142: where auction_header_id = p_document_id;
143:
144: --
145: -- we only want to raise exception if we get zero or more

Line 304: from pon_auction_headers_all

300: x_result := FND_API.g_ret_sts_success;
301:
302: select doctype_id, open_bidding_date, close_bidding_date, org_id
303: into l_doc_type_id, l_open_date, l_close_date, l_org_id
304: from pon_auction_headers_all
305: where auction_header_id = p_auction_id;
306:
307: l_bus_doc_type := get_response_doc_type(l_doc_type_id);
308:

Line 515: from pon_auction_headers_all a,

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
518: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend)
519: AND bid_status in ( 'ACTIVE', 'RESUBMISSION') ;

Line 516: pon_auction_headers_all b

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
518: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend)
519: AND bid_status in ( 'ACTIVE', 'RESUBMISSION') ;
520:

Line 527: FROM pon_auction_headers_all

523: */
524:
525: CURSOR all_amendments is
526: SELECT auction_header_id
527: FROM pon_auction_headers_all
528: WHERE auction_header_id in (select a.auction_header_id
529: from pon_auction_headers_all a,
530: pon_auction_headers_all b
531: where b.auction_header_id = p_auction_header_id

Line 529: from pon_auction_headers_all a,

525: CURSOR all_amendments is
526: SELECT auction_header_id
527: FROM pon_auction_headers_all
528: WHERE auction_header_id in (select a.auction_header_id
529: from pon_auction_headers_all a,
530: pon_auction_headers_all b
531: where b.auction_header_id = p_auction_header_id
532: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend);
533:

Line 530: pon_auction_headers_all b

526: SELECT auction_header_id
527: FROM pon_auction_headers_all
528: WHERE auction_header_id in (select a.auction_header_id
529: from pon_auction_headers_all a,
530: pon_auction_headers_all b
531: where b.auction_header_id = p_auction_header_id
532: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend);
533:
534:

Line 557: from pon_auction_headers_all

553: -- we can not change the org_id for amendment or new round
554: --
555: select org_id
556: into l_org_id
557: from pon_auction_headers_all
558: where auction_header_id = p_auction_header_id;
559:
560: --
561: -- Get the current policy

Line 706: x_doctype_id pon_auction_headers_all.doctype_id%type;

702: l_response_doc_type VARCHAR2(30);
703: l_return_status VARCHAR2(1);
704: l_msg_data VARCHAR2(250);
705: l_api_name CONSTANT VARCHAR2(30) := 'cancelDeliverables';
706: x_doctype_id pon_auction_headers_all.doctype_id%type;
707:
708:
709: -- multi-org related changes
710: l_old_org_id NUMBER;

Line 724: from pon_auction_headers_all

720: x_doctype_id :=p_doc_type_id;
721:
722: if (x_doctype_id =-1) then
723: select doctype_id into x_doctype_id
724: from pon_auction_headers_all
725: where auction_header_id=p_auction_header_id;
726: end if;
727:
728: if (is_contracts_installed() = FND_API.G_TRUE) then

Line 734: from pon_auction_headers_all

730: BEGIN
731:
732: select org_id
733: into l_org_id
734: from pon_auction_headers_all
735: where auction_header_id = p_auction_header_id;
736:
737: -- get the contract doc type depending on p_doc_type_id
738: l_negotiation_doc_type := get_negotiation_doc_type(x_doctype_id);

Line 863: from pon_auction_headers_all

859: l_negotiation_doc_type := get_negotiation_doc_type(p_doc_type_id);
860:
861: select org_id
862: into l_org_id
863: from pon_auction_headers_all
864: where auction_header_id = p_auction_header_id;
865:
866: --
867: -- Get the current policy

Line 962: FROM pon_auction_headers_all

958: BEGIN
959:
960: SELECT doctype_id, view_by_Date, open_bidding_date, close_bidding_date, org_id
961: INTO l_doc_type_id, l_view_by_date, l_open_date, l_close_bidding_date, l_org_id
962: FROM pon_auction_headers_all
963: WHERE auction_header_id = p_auction_header_id;
964: -- get the contract doc type depending on p_doc_type_id
965:
966: l_negotiation_doc_type := get_negotiation_doc_type(l_doc_type_id);

Line 1063: l_internal_party_id Number := null; -- pon_auction_headers_all.trading_partner_id

1059:
1060: l_initializeStatus_yn Varchar2(1) := 'N';
1061: l_reset_fixed_date_yn Varchar2(1) := 'N';
1062:
1063: l_internal_party_id Number := null; -- pon_auction_headers_all.trading_partner_id
1064: l_internal_contact_id Number := null; --
1065: l_internal_contact_pid Number :=null;
1066: l_contractualonly Varchar2(1) := 'N';
1067:

Line 1098: from pon_auction_headers_all h,

1094: -- design of sourcing
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:

Line 1206: pon_auction_headers_all a

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:
1210: l_bus_doc_type := get_response_doc_type(l_doc_type_id);

Line 1318: from pon_auction_headers_all

1314: begin
1315:
1316: select org_id
1317: into l_org_id
1318: from pon_auction_headers_all
1319: where auction_header_id = p_auction_number;
1320:
1321: --
1322: -- Get the current policy

Line 1381: used to set pon_auction_headers_all.conterms_exist_flag

1377: p_doc_type IN document type for contract
1378: p_doc_id IN document id
1379:
1380: COMMENT : check if negotiation has contract terms
1381: used to set pon_auction_headers_all.conterms_exist_flag
1382: ======================================================================*/
1383:
1384: FUNCTION contract_terms_exist(p_doc_type IN VARCHAR2,
1385: p_doc_id IN NUMBER) RETURN VARCHAR2 IS

Line 1394: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

1390: -- l_org_id NUMBER;
1391: l_msg_data VARCHAR2(250);
1392: l_msg_count NUMBER;
1393: l_return_status VARCHAR2(1);
1394: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1395:
1396: BEGIN
1397:
1398: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);

Line 1412: -- from pon_auction_headers_all

1408: end if;
1409:
1410: -- select org_id
1411: -- into l_org_id
1412: -- from pon_auction_headers_all
1413: -- where auction_header_id = l_auction_header_id;
1414:
1415: --
1416: -- Get the current policy

Line 1474: from pon_auction_headers_all

1470: aname => 'AUCTION_ID');
1471:
1472: select org_id
1473: into l_org_id
1474: from pon_auction_headers_all
1475: where auction_header_id = v_doc_id;
1476:
1477: --
1478: -- Get the current policy

Line 1548: from pon_auction_headers_all

1544: aname => 'AUCTION_ID');
1545:
1546: select org_id
1547: into l_org_id
1548: from pon_auction_headers_all
1549: where auction_header_id = v_doc_id;
1550:
1551: --
1552: -- Get the current policy

Line 1627: from pon_auction_headers_all

1623: aname => 'AUCTION_ID');
1624:
1625: select org_id
1626: into l_org_id
1627: from pon_auction_headers_all
1628: where auction_header_id = v_doc_id;
1629:
1630: --
1631: -- Get the current policy

Line 1701: from pon_auction_headers_all

1697: aname => 'AUCTION_ID');
1698:
1699: select org_id
1700: into l_org_id
1701: from pon_auction_headers_all
1702: where auction_header_id = v_doc_id;
1703:
1704: --
1705: -- Get the current policy

Line 1777: from pon_auction_headers_all

1773: aname => 'AUCTION_ID');
1774:
1775: select org_id
1776: into l_org_id
1777: from pon_auction_headers_all
1778: where auction_header_id = v_doc_id;
1779:
1780: --
1781: -- Get the current policy

Line 1852: from pon_auction_headers_all

1848: aname => 'AUCTION_ID');
1849:
1850: select org_id
1851: into l_org_id
1852: from pon_auction_headers_all
1853: where auction_header_id = v_doc_id;
1854:
1855: --
1856: -- Get the current policy

Line 2020: from pon_auction_headers_all

2016:
2017: BEGIN
2018:
2019: select close_bidding_date into l_old_close_date
2020: from pon_auction_headers_all
2021: where auction_header_id = p_auction_header_id_prev;
2022:
2023: -- if the close date was changed during the amendment process
2024: -- then we need to update all the deliverables in the new and old

Line 2126: from pon_auction_headers_all

2122: BEGIN
2123:
2124: select org_id
2125: into l_org_id
2126: from pon_auction_headers_all
2127: where auction_header_id = p_document_id;
2128:
2129: --
2130: -- Get the current policy

Line 2213: from pon_auction_headers_all

2209: BEGIN
2210:
2211: select org_id
2212: into l_org_id
2213: from pon_auction_headers_all
2214: where auction_header_id = p_document_id;
2215:
2216: --
2217: -- Get the current policy

Line 2301: from pon_auction_headers_all

2297: BEGIN
2298:
2299: select org_id
2300: into l_org_id
2301: from pon_auction_headers_all
2302: where auction_header_id = p_document_id;
2303:
2304: --
2305: -- Get the current policy