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.

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 147: from pon_auction_headers_all

143: BEGIN
144:
145: select org_id
146: into l_org_id
147: from pon_auction_headers_all
148: where auction_header_id = p_document_id;
149:
150: --
151: -- we only want to raise exception if we get zero or more

Line 310: from pon_auction_headers_all

306: x_result := FND_API.g_ret_sts_success;
307:
308: select doctype_id, open_bidding_date, close_bidding_date, org_id
309: into l_doc_type_id, l_open_date, l_close_date, l_org_id
310: from pon_auction_headers_all
311: where auction_header_id = p_auction_id;
312:
313: l_bus_doc_type := get_response_doc_type(l_doc_type_id);
314:

Line 521: from pon_auction_headers_all a,

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

Line 522: pon_auction_headers_all b

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

Line 533: FROM pon_auction_headers_all

529: */
530:
531: CURSOR all_amendments is
532: SELECT auction_header_id
533: FROM pon_auction_headers_all
534: WHERE auction_header_id in (select a.auction_header_id
535: from pon_auction_headers_all a,
536: pon_auction_headers_all b
537: where b.auction_header_id = p_auction_header_id

Line 535: from pon_auction_headers_all a,

531: CURSOR all_amendments is
532: SELECT auction_header_id
533: FROM pon_auction_headers_all
534: WHERE auction_header_id in (select a.auction_header_id
535: from pon_auction_headers_all a,
536: pon_auction_headers_all b
537: where b.auction_header_id = p_auction_header_id
538: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend);
539:

Line 536: pon_auction_headers_all b

532: SELECT auction_header_id
533: FROM pon_auction_headers_all
534: WHERE auction_header_id in (select a.auction_header_id
535: from pon_auction_headers_all a,
536: pon_auction_headers_all b
537: where b.auction_header_id = p_auction_header_id
538: and b.auction_header_id_orig_amend = a.auction_header_id_orig_amend);
539:
540:

Line 563: from pon_auction_headers_all

559: -- we can not change the org_id for amendment or new round
560: --
561: select org_id
562: into l_org_id
563: from pon_auction_headers_all
564: where auction_header_id = p_auction_header_id;
565:
566: --
567: -- Get the current policy

Line 712: x_doctype_id pon_auction_headers_all.doctype_id%type;

708: l_response_doc_type VARCHAR2(30);
709: l_return_status VARCHAR2(1);
710: l_msg_data VARCHAR2(250);
711: l_api_name CONSTANT VARCHAR2(30) := 'cancelDeliverables';
712: x_doctype_id pon_auction_headers_all.doctype_id%type;
713:
714:
715: -- multi-org related changes
716: l_old_org_id NUMBER;

Line 730: from pon_auction_headers_all

726: x_doctype_id :=p_doc_type_id;
727:
728: if (x_doctype_id =-1) then
729: select doctype_id into x_doctype_id
730: from pon_auction_headers_all
731: where auction_header_id=p_auction_header_id;
732: end if;
733:
734: if (is_contracts_installed() = FND_API.G_TRUE) then

Line 740: from pon_auction_headers_all

736: BEGIN
737:
738: select org_id
739: into l_org_id
740: from pon_auction_headers_all
741: where auction_header_id = p_auction_header_id;
742:
743: -- get the contract doc type depending on p_doc_type_id
744: l_negotiation_doc_type := get_negotiation_doc_type(x_doctype_id);

Line 869: from pon_auction_headers_all

865: l_negotiation_doc_type := get_negotiation_doc_type(p_doc_type_id);
866:
867: select org_id
868: into l_org_id
869: from pon_auction_headers_all
870: where auction_header_id = p_auction_header_id;
871:
872: --
873: -- Get the current policy

Line 968: FROM pon_auction_headers_all

964: BEGIN
965:
966: SELECT doctype_id, view_by_Date, open_bidding_date, close_bidding_date, org_id
967: INTO l_doc_type_id, l_view_by_date, l_open_date, l_close_bidding_date, l_org_id
968: FROM pon_auction_headers_all
969: WHERE auction_header_id = p_auction_header_id;
970: -- get the contract doc type depending on p_doc_type_id
971:
972: l_negotiation_doc_type := get_negotiation_doc_type(l_doc_type_id);

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

1065:
1066: l_initializeStatus_yn Varchar2(1) := 'N';
1067: l_reset_fixed_date_yn Varchar2(1) := 'N';
1068:
1069: l_internal_party_id Number := null; -- pon_auction_headers_all.trading_partner_id
1070: l_internal_contact_id Number := null; --
1071: l_internal_contact_pid Number :=null;
1072: l_contractualonly Varchar2(1) := 'N';
1073:

Line 1104: from pon_auction_headers_all h,

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

Line 1212: pon_auction_headers_all a

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

Line 1324: from pon_auction_headers_all

1320: begin
1321:
1322: select org_id
1323: into l_org_id
1324: from pon_auction_headers_all
1325: where auction_header_id = p_auction_number;
1326:
1327: --
1328: -- Get the current policy

Line 1387: Earlier used to set pon_auction_headers_all.conterms_exist_flag

1383: p_doc_type IN document type for contract
1384: p_doc_id IN document id
1385:
1386: COMMENT : check if negotiation has contract terms
1387: Earlier used to set pon_auction_headers_all.conterms_exist_flag
1388: After cdrls project, deliverables can be added without
1389: applying a contract template. Use other function contract_terms_or_del_exist
1390: to set pon_auction_headers_all.conterms_exist_flag
1391: ======================================================================*/

Line 1390: to set pon_auction_headers_all.conterms_exist_flag

1386: COMMENT : check if negotiation has contract terms
1387: Earlier used to set pon_auction_headers_all.conterms_exist_flag
1388: After cdrls project, deliverables can be added without
1389: applying a contract template. Use other function contract_terms_or_del_exist
1390: to set pon_auction_headers_all.conterms_exist_flag
1391: ======================================================================*/
1392:
1393: FUNCTION contract_terms_exist(p_doc_type IN VARCHAR2,
1394: p_doc_id IN NUMBER) RETURN VARCHAR2 IS

Line 1403: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

1399: -- l_org_id NUMBER;
1400: l_msg_data VARCHAR2(250);
1401: l_msg_count NUMBER;
1402: l_return_status VARCHAR2(1);
1403: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1404:
1405: BEGIN
1406:
1407: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);

Line 1421: -- from pon_auction_headers_all

1417: end if;
1418:
1419: -- select org_id
1420: -- into l_org_id
1421: -- from pon_auction_headers_all
1422: -- where auction_header_id = l_auction_header_id;
1423:
1424: --
1425: -- Get the current policy

Line 1467: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

1463: -- l_org_id NUMBER;
1464: l_msg_data VARCHAR2(250);
1465: l_msg_count NUMBER;
1466: l_return_status VARCHAR2(1);
1467: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1468:
1469: BEGIN
1470:
1471: get_auction_header_id(p_doc_type, p_doc_id, l_auction_header_id, l_return_status, l_msg_data, l_msg_count);

Line 1498: used to set pon_auction_headers_all.conterms_exist_flag

1494: p_doc_type IN document type for contract
1495: p_doc_id IN document id
1496:
1497: COMMENT : check if negotiation has contract terms or deliverables
1498: used to set pon_auction_headers_all.conterms_exist_flag
1499: ======================================================================*/
1500: FUNCTION contract_terms_or_del_exist(p_doc_type IN VARCHAR2,
1501: p_doc_id IN NUMBER) RETURN VARCHAR2 IS
1502:

Line 1506: l_auction_header_id pon_auction_headers_all.auction_header_id%type;

1502:
1503: l_msg_data VARCHAR2(250);
1504: l_msg_count NUMBER;
1505: l_return_status VARCHAR2(1);
1506: l_auction_header_id pon_auction_headers_all.auction_header_id%type;
1507: l_terms_exist VARCHAR2(1);
1508: l_del_exist VARCHAR2(1);
1509:
1510: BEGIN

Line 1576: from pon_auction_headers_all

1572: aname => 'AUCTION_ID');
1573:
1574: select org_id
1575: into l_org_id
1576: from pon_auction_headers_all
1577: where auction_header_id = v_doc_id;
1578:
1579: --
1580: -- Get the current policy

Line 1650: from pon_auction_headers_all

1646: aname => 'AUCTION_ID');
1647:
1648: select org_id
1649: into l_org_id
1650: from pon_auction_headers_all
1651: where auction_header_id = v_doc_id;
1652:
1653: --
1654: -- Get the current policy

Line 1729: from pon_auction_headers_all

1725: aname => 'AUCTION_ID');
1726:
1727: select org_id
1728: into l_org_id
1729: from pon_auction_headers_all
1730: where auction_header_id = v_doc_id;
1731:
1732: --
1733: -- Get the current policy

Line 1803: from pon_auction_headers_all

1799: aname => 'AUCTION_ID');
1800:
1801: select org_id
1802: into l_org_id
1803: from pon_auction_headers_all
1804: where auction_header_id = v_doc_id;
1805:
1806: --
1807: -- Get the current policy

Line 1879: from pon_auction_headers_all

1875: aname => 'AUCTION_ID');
1876:
1877: select org_id
1878: into l_org_id
1879: from pon_auction_headers_all
1880: where auction_header_id = v_doc_id;
1881:
1882: --
1883: -- Get the current policy

Line 1954: from pon_auction_headers_all

1950: aname => 'AUCTION_ID');
1951:
1952: select org_id
1953: into l_org_id
1954: from pon_auction_headers_all
1955: where auction_header_id = v_doc_id;
1956:
1957: --
1958: -- Get the current policy

Line 2122: from pon_auction_headers_all

2118:
2119: BEGIN
2120:
2121: select close_bidding_date into l_old_close_date
2122: from pon_auction_headers_all
2123: where auction_header_id = p_auction_header_id_prev;
2124:
2125: -- if the close date was changed during the amendment process
2126: -- then we need to update all the deliverables in the new and old

Line 2228: from pon_auction_headers_all

2224: BEGIN
2225:
2226: select org_id
2227: into l_org_id
2228: from pon_auction_headers_all
2229: where auction_header_id = p_document_id;
2230:
2231: --
2232: -- Get the current policy

Line 2315: from pon_auction_headers_all

2311: BEGIN
2312:
2313: select org_id
2314: into l_org_id
2315: from pon_auction_headers_all
2316: where auction_header_id = p_document_id;
2317:
2318: --
2319: -- Get the current policy

Line 2403: from pon_auction_headers_all

2399: BEGIN
2400:
2401: select org_id
2402: into l_org_id
2403: from pon_auction_headers_all
2404: where auction_header_id = p_document_id;
2405:
2406: --
2407: -- Get the current policy