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_AUCTION_APPROVAL_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 251: from pon_neg_team_members neg, pon_auction_headers_all auc

247:
248: select neg.approver_flag, neg.approval_status, auc.approval_status,
249: wf_approval_item_key
250: into l_user_approval,l_user_status,l_auction_status,l_parent_process_itemKey
251: from pon_neg_team_members neg, pon_auction_headers_all auc
252: where auc.auction_header_id = p_auction_header_id
253: and neg.auction_header_id= auc.auction_header_id
254: and neg.user_id = l_user_id;
255:

Line 313: from pon_neg_team_members neg, pon_auction_headers_all auc

309: begin
310: select neg.approver_flag, neg.approval_status, auc.approval_status,
311: wf_approval_item_key
312: into l_user_approval,l_user_status,l_auction_status,l_itemKey
313: from pon_neg_team_members neg, pon_auction_headers_all auc
314: where auc.auction_header_id = p_auction_header_id
315: and neg.auction_header_id= auc.auction_header_id
316: and neg.user_id = l_user_id;
317:

Line 344: FROM pon_auction_headers_all

340: --added signed date setting the item attribute date.
341:
342: SELECT wf_approval_item_key
343: INTO l_item_key_main_process
344: FROM pon_auction_headers_all
345: WHERE auction_header_id = p_auction_header_id;
346:
347: --added by amundhra for Federal CLM
348: --added signed date setting the item attribute date.

Line 398: update pon_auction_headers_all

394: begin
395: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'AUCTION_HEADER_ID');
398: update pon_auction_headers_all
399: set auction_status = 'CANCELLED'
400: where auction_header_id=l_auction_header_id;
401:
402: end UPDATE_DOC_TO_CANCELLED;

Line 430: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

426: l_open_bidding_date date;
427: l_auction_title varchar2(80);
428: l_creator_time_zone varchar2(80);
429: l_doctype_group_name varchar2(100);
430: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
431: l_msg_suffix varchar2(10);
432: l_auction_contact_id number;
433: l_language_code varchar2(100);
434: l_timezone varchar2(100);

Line 443: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

439: l_timeout_factor number;
440: l_open_date_in_tz date;
441: l_close_date_in_tz date;
442: l_open_auction_now_flag varchar2(1);
443: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
444: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
445: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
447: l_round_number NUMBER;

Line 444: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

440: l_open_date_in_tz date;
441: l_close_date_in_tz date;
442: l_open_auction_now_flag varchar2(1);
443: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
444: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
445: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
447: l_round_number NUMBER;
448: l_amendment_number NUMBER;

Line 445: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;

441: l_close_date_in_tz date;
442: l_open_auction_now_flag varchar2(1);
443: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
444: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
445: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
447: l_round_number NUMBER;
448: l_amendment_number NUMBER;
449: l_auction_header_id_orig_amend NUMBER;

Line 446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;

442: l_open_auction_now_flag varchar2(1);
443: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
444: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
445: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
447: l_round_number NUMBER;
448: l_amendment_number NUMBER;
449: l_auction_header_id_orig_amend NUMBER;
450: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

Line 450: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

446: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
447: l_round_number NUMBER;
448: l_amendment_number NUMBER;
449: l_auction_header_id_orig_amend NUMBER;
450: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
451: l_review_changes_url VARCHAR2(2000);
452: l_preview_date DATE;
453: l_preview_date_in_tz DATE;
454: l_timezone1_disp VARCHAR2(240);

Line 459: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;

455: l_submit_user_id number;
456:
457: -- Added for Federal Documents
458: l_is_federal NUMBER DEFAULT 0;
459: l_doctype_id PON_AUCTION_HEADERS_ALL.DOCTYPE_ID%TYPE;
460: l_manage_draft_url VARCHAR2(2000);
461:
462: l_resp_id NUMBER; -- bug 11732401
463: l_appl_id NUMBER; -- bug 11732401

Line 474: from fnd_user fnd,pon_auction_headers_all pon

470: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
471: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,
472: open_bidding_date, close_bidding_date, nvl(auction_round_number, 1),
473: nvl(amendment_number, 0), auction_header_id_orig_amend, view_by_date
474: from fnd_user fnd,pon_auction_headers_all pon
475: where fnd.person_party_id = pon.trading_partner_contact_id and
476: pon.auction_header_id = p_auction_header_id and
477: rownum=1;
478:

Line 620: from pon_auction_headers_all auh, pon_auc_doctypes dt

616: avalue => l_creator_user_id);
617:
618: select dt.doctype_group_name,auh.doctype_id
619: into l_doctype_group_name,l_doctype_id
620: from pon_auction_headers_all auh, pon_auc_doctypes dt
621: where auh.auction_header_id = p_auction_header_id
622: and auh.doctype_id = dt.doctype_id;
623:
624: /* Added for Federal CLM Solicitation Amendments Project.

Line 744: from pon_auction_headers_all

740: aname => 'NOTE_TO_APPROVERS',
741: avalue => p_note_to_approvers);
742: select document_number
743: into l_orig_document_number
744: from pon_auction_headers_all
745: where auction_header_id = l_auction_header_id_orig_amend;
746:
747: -- set notification subjects
748: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);

Line 807: UPDATE pon_auction_headers_all set

803: wf_engine.StartProcess (itemType => l_itemType,
804: itemKey => l_itemKey );
805:
806: /* Update Headers table */
807: UPDATE pon_auction_headers_all set
808: wf_approval_item_key = l_itemKey,
809: approval_status = 'INPROCESS'
810: WHERE auction_header_id = p_auction_header_id;
811:

Line 848: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

844: l_note_to_approvers Varchar2(2000);
845: l_publish_auction_now_flag varchar2(1);
846: l_open_auction_now_flag varchar2(1);
847: l_reminder_date date;
848: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
849: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
850: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
851: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
852: l_auction_start_date DATE;

Line 849: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

845: l_publish_auction_now_flag varchar2(1);
846: l_open_auction_now_flag varchar2(1);
847: l_reminder_date date;
848: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
849: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
850: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
851: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
852: l_auction_start_date DATE;
853: l_auction_end_date DATE;

Line 850: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

846: l_open_auction_now_flag varchar2(1);
847: l_reminder_date date;
848: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
849: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
850: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
851: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
852: l_auction_start_date DATE;
853: l_auction_end_date DATE;
854: l_timezone_dsp varchar2(100);

Line 851: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

847: l_reminder_date date;
848: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
849: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
850: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
851: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
852: l_auction_start_date DATE;
853: l_auction_end_date DATE;
854: l_timezone_dsp varchar2(100);
855: l_review_changes_url VARCHAR2(2000);

Line 856: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

852: l_auction_start_date DATE;
853: l_auction_end_date DATE;
854: l_timezone_dsp varchar2(100);
855: l_review_changes_url VARCHAR2(2000);
856: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
857: l_round_number NUMBER;
858: l_amendment_number NUMBER;
859: l_preview_date_in_tz DATE;
860: l_timezone1_disp varchar2(240);

Line 881: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u

877: trading_partner_contact_id auction_contact_id,
878: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
879: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
880: auc.auction_header_id_orig_amend
881: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
882: where neg.auction_header_id = auc.auction_header_id and
883: auc.auction_header_id = p_auction_header_id
884: and neg.APPROVER_FLAG ='Y'
885: AND neg.MENU_NAME <> 'EMD_ADMIN' --FOR ERIC TEST ONLY

Line 1252: from pon_auction_headers_all

1248: -- bug 11732401 end
1249:
1250: select document_number
1251: into l_orig_document_number
1252: from pon_auction_headers_all
1253: where auction_header_id = r1.auction_header_id_orig_amend;
1254:
1255: -- set notification subjects
1256: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);

Line 1290: pon_auction_headers_all auc

1286: BEGIN
1287: SELECT 'Y'
1288: INTO l_result
1289: FROM
1290: pon_auction_headers_all auc
1291: , pon_neg_team_members neg
1292: WHERE auc.auction_header_id = neg.auction_header_id
1293: AND auc.auction_header_id = p_auction_header_id
1294: AND auc.approval_status = 'INPROCESS'

Line 1313: from pon_auction_headers_all auc,

1309: ELSE --NORMAL APPROVAL USER
1310: begin
1311: select 'Y'
1312: into l_result
1313: from pon_auction_headers_all auc,
1314: pon_neg_team_members neg
1315: where auc.auction_header_id = neg.auction_header_id
1316: and auc.auction_header_id = p_auction_header_id
1317: and auc.approval_status = 'INPROCESS'

Line 1459: from pon_auction_headers_all

1455:
1456: /* Get the top process item key */
1457: Select wf_approval_item_key
1458: into l_top_process_itemKey
1459: from pon_auction_headers_all
1460: where auction_header_id = p_auctionHeaderId;
1461:
1462: if (p_decision = 'APPROVE') then
1463: Process_If_Doc_Approved(p_auctionHeaderId,l_top_process_itemKey);

Line 1590: FROM pon_auction_headers_all

1586:
1587: BEGIN
1588: SELECT effective_date
1589: INTO l_effective_date
1590: FROM pon_auction_headers_all
1591: WHERE auction_header_id = p_auction_header_id;
1592:
1593:
1594:

Line 1602: UPDATE pon_auction_headers_all

1598:
1599:
1600:
1601:
1602: UPDATE pon_auction_headers_all
1603: SET effective_date = p_signed_date,
1604: signed_date = p_signed_date
1605: WHERE auction_header_id = p_auction_header_id;
1606:

Line 1609: UPDATE pon_auction_headers_all

1605: WHERE auction_header_id = p_auction_header_id;
1606:
1607: ELSE
1608:
1609: UPDATE pon_auction_headers_all
1610: SET signed_date = p_signed_date
1611: WHERE auction_header_id = p_auction_header_id;
1612:
1613: END IF;

Line 1632: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

1628: l_language_code varchar2(100);
1629: l_timezone varchar2(100);
1630: l_timezone_disp varchar2(100);
1631: l_oex_timezone varchar2(100);
1632: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1633: l_preview_date_in_tz DATE;
1634: l_timezone1_disp varchar2(240);
1635: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1636:

Line 1752: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

1748: l_language_code varchar2(100);
1749: l_timezone varchar2(100);
1750: l_timezone_disp varchar2(100);
1751: l_oex_timezone varchar2(100);
1752: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1753: l_preview_date_in_tz DATE;
1754: l_timezone1_disp varchar2(240);
1755: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1756:

Line 2009: update pon_auction_headers_all

2005: * neg the lock might remain with the approver in case he
2006: * navigated to the review page. Bug 4777895.
2007: */
2008:
2009: update pon_auction_headers_all
2010: set approval_status = p_status,
2011: draft_locked = 'N',
2012: draft_locked_by = null,
2013: draft_locked_by_contact_id = null,

Line 2018: --INSERT INTO ERIC_LOG VALUES (i ||'row has been updated in pon_auction_headers_all','','','','','','',''); --for eric test only

2014: draft_locked_date = null
2015: where auction_header_id = p_auction_header_id;
2016:
2017: i:=SQL%ROWCOUNT;
2018: --INSERT INTO ERIC_LOG VALUES (i ||'row has been updated in pon_auction_headers_all','','','','','','',''); --for eric test only
2019: --INSERT INTO ERIC_LOG VALUES ('go out AUCTION Branch','','','','','','',''); --for eric test only
2020: end if;
2021:
2022: end UPD_AUCTION_STATUSHISTORY;

Line 2143: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

2139: l_note_to_approvers VARCHAR2(2000);
2140: l_publish_auction_now_flag VARCHAR2(1);
2141: l_open_auction_now_flag VARCHAR2(1);
2142: l_reminder_date DATE;
2143: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2144: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
2145: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2146: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2147: l_auction_start_date DATE;

Line 2144: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

2140: l_publish_auction_now_flag VARCHAR2(1);
2141: l_open_auction_now_flag VARCHAR2(1);
2142: l_reminder_date DATE;
2143: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2144: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
2145: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2146: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2147: l_auction_start_date DATE;
2148: l_auction_end_date DATE;

Line 2145: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

2141: l_open_auction_now_flag VARCHAR2(1);
2142: l_reminder_date DATE;
2143: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2144: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
2145: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2146: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2147: l_auction_start_date DATE;
2148: l_auction_end_date DATE;
2149: l_timezone_dsp VARCHAR2(100);

Line 2146: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

2142: l_reminder_date DATE;
2143: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
2144: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
2145: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2146: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
2147: l_auction_start_date DATE;
2148: l_auction_end_date DATE;
2149: l_timezone_dsp VARCHAR2(100);
2150: l_review_emd_changes_url VARCHAR2(2000);

Line 2152: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

2148: l_auction_end_date DATE;
2149: l_timezone_dsp VARCHAR2(100);
2150: l_review_emd_changes_url VARCHAR2(2000);
2151: l_review_changes_url VARCHAR2(2000);
2152: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2153: l_round_number NUMBER;
2154: l_amendment_number NUMBER;
2155: l_preview_date_in_tz DATE;
2156: l_timezone1_disp VARCHAR2(240);

Line 2181: , pon_auction_headers_all auc

2177: , nvl(auc.open_auction_now_flag,'N') open_auction_now_flag
2178: , auc.auction_header_id_orig_amend
2179: FROM
2180: pon_neg_team_members neg
2181: , pon_auction_headers_all auc
2182: , fnd_user u
2183: WHERE neg.auction_header_id = auc.auction_header_id
2184: AND auc.auction_header_id = p_auction_header_id
2185: AND MENU_NAME='EMD_ADMIN'

Line 2518: FROM pon_auction_headers_all

2514: , avalue => l_note_to_approvers);
2515:
2516: SELECT document_number
2517: INTO l_orig_document_number
2518: FROM pon_auction_headers_all
2519: WHERE auction_header_id = r1.auction_header_id_orig_amend;
2520:
2521: -- set notification subjects
2522: set_notification_subject( l_itemType

Line 2746: l_source_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

2742: actid in number,
2743: uncmode in varchar2,
2744: resultout out nocopy varchar2) IS
2745:
2746: l_source_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2747: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2748: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2749: l_request_id NUMBER;
2750: l_return_status VARCHAR2(30);

Line 2747: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

2743: uncmode in varchar2,
2744: resultout out nocopy varchar2) IS
2745:
2746: l_source_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2747: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2748: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2749: l_request_id NUMBER;
2750: l_return_status VARCHAR2(30);
2751: l_msg_count NUMBER;

Line 2748: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

2744: resultout out nocopy varchar2) IS
2745:
2746: l_source_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2747: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2748: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
2749: l_request_id NUMBER;
2750: l_return_status VARCHAR2(30);
2751: l_msg_count NUMBER;
2752: l_msg_data VARCHAR2(500);

Line 2754: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;

2750: l_return_status VARCHAR2(30);
2751: l_msg_count NUMBER;
2752: l_msg_data VARCHAR2(500);
2753:
2754: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
2755: l_msg_suffix VARCHAR2(10);
2756: l_rev_message VARCHAR2(30);
2757: l_success_msg VARCHAR2(1000);
2758:

Line 2907: from pon_auction_headers_all

2903: Begin
2904: --Get work flow item key
2905: select wf_approval_item_key
2906: into l_itemKey
2907: from pon_auction_headers_all
2908: where auction_header_id = p_auction_header_id;
2909: --Get the attributes from workflow
2910: x_return_status := wf_engine.GetItemAttrText (itemtype => l_itemType,
2911: itemkey => l_itemKey,

Line 2929: from pon_auction_headers_all

2925: itemkey => l_itemKey,
2926: aname => 'NEW_CONF_DOC_CLM');
2927: select document_number
2928: into x_amend_doc_number
2929: from pon_auction_headers_all
2930: where
2931: auction_header_id = p_auction_header_id;
2932:
2933: if x_return_status = 'CONC_REQ_SUBMITTED' then

Line 2975: from pon_auction_headers_all

2971:
2972: --Get work flow item key
2973: select wf_approval_item_key
2974: into l_itemKey
2975: from pon_auction_headers_all
2976: where auction_header_id = p_auction_header_id;
2977:
2978: --set workflow item attribute CANCELNOTETOSUPPLIERS.
2979: wf_engine.SetItemAttrText (itemtype => l_itemType,

Line 2994: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

2990: itemkey in varchar2,
2991: actid in number,
2992: uncmode in varchar2,
2993: resultout out nocopy varchar2) IS
2994: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
2995: Begin
2996: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
2997: itemkey => itemkey,
2998: aname => 'AUCTION_HEADER_ID');

Line 3001: from pon_auction_headers_all

2997: itemkey => itemkey,
2998: aname => 'AUCTION_HEADER_ID');
2999: select nvl(cancel_amendment,'N')
3000: into resultout
3001: from pon_auction_headers_all
3002: where
3003: auction_header_id = l_auction_header_id;
3004:
3005: End Is_Cancel_Amendment;

Line 3016: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

3012: actid in number,
3013: uncmode in varchar2,
3014: resultout out nocopy varchar2) IS
3015:
3016: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
3017: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3018: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
3019: l_cancel_note_to_supplier varchar2(2000);
3020: l_error_code varchar2(1000);

Line 3017: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

3013: uncmode in varchar2,
3014: resultout out nocopy varchar2) IS
3015:
3016: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
3017: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3018: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
3019: l_cancel_note_to_supplier varchar2(2000);
3020: l_error_code varchar2(1000);
3021: l_auction_id_prev_doc PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

Line 3018: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;

3014: resultout out nocopy varchar2) IS
3015:
3016: l_auction_header_id PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
3017: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3018: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
3019: l_cancel_note_to_supplier varchar2(2000);
3020: l_error_code varchar2(1000);
3021: l_auction_id_prev_doc PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
3022:

Line 3021: l_auction_id_prev_doc PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;

3017: l_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
3018: l_revision PON_AUCTION_HEADERS_ALL.REVISION%TYPE;
3019: l_cancel_note_to_supplier varchar2(2000);
3020: l_error_code varchar2(1000);
3021: l_auction_id_prev_doc PON_AUCTION_HEADERS_ALL.AUCTION_HEADER_ID%TYPE;
3022:
3023: l_msg_data varchar2(250);
3024: l_msg_count number;
3025: l_return_status varchar2(1);

Line 3049: from pon_auction_headers_all pon1

3045:
3046: if l_error_code = 'SUCCESS' then
3047: select pon1.auction_header_id,pon1.document_number,pon1.revision
3048: into l_auction_id_prev_doc,l_document_number,l_revision
3049: from pon_auction_headers_all pon1
3050: where
3051: pon1.auction_header_id = (select pon2.auction_header_id_prev_amend
3052: from pon_auction_headers_all pon2
3053: where pon2.auction_header_id = l_auction_header_id);

Line 3052: from pon_auction_headers_all pon2

3048: into l_auction_id_prev_doc,l_document_number,l_revision
3049: from pon_auction_headers_all pon1
3050: where
3051: pon1.auction_header_id = (select pon2.auction_header_id_prev_amend
3052: from pon_auction_headers_all pon2
3053: where pon2.auction_header_id = l_auction_header_id);
3054:
3055: PON_CONTERMS_UTL_PVT.cancelDeliverables(l_auction_id_prev_doc,
3056: -1,

Line 3111: from pon_auction_headers_all

3107: Begin
3108: --Get work flow item key
3109: select wf_approval_item_key
3110: into l_itemKey
3111: from pon_auction_headers_all
3112: where auction_header_id = p_auction_header_id;
3113: --Get the attributes from workflow
3114: x_cnf_doc_auc_head_id := wf_engine.GetItemAttrNumber(itemtype => l_itemType,
3115: itemkey => l_itemKey,

Line 3129: from pon_auction_headers_all

3125: itemkey => l_itemKey,
3126: aname => 'NEW_CONF_DOC_CLM');
3127: select document_number
3128: into x_amend_doc_number
3129: from pon_auction_headers_all
3130: where
3131: auction_header_id = p_auction_header_id;
3132:
3133: End get_cancel_doc_params_wf;