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 125: from pon_neg_team_members neg, pon_auction_headers_all auc

121:
122: select neg.approver_flag, neg.approval_status, auc.approval_status,
123: wf_approval_item_key
124: into l_user_approval,l_user_status,l_auction_status,l_parent_process_itemKey
125: from pon_neg_team_members neg, pon_auction_headers_all auc
126: where auc.auction_header_id = p_auction_header_id
127: and neg.auction_header_id= auc.auction_header_id
128: and neg.user_id = l_user_id;
129:

Line 181: from pon_neg_team_members neg, pon_auction_headers_all auc

177: begin
178: select neg.approver_flag, neg.approval_status, auc.approval_status,
179: wf_approval_item_key
180: into l_user_approval,l_user_status,l_auction_status,l_itemKey
181: from pon_neg_team_members neg, pon_auction_headers_all auc
182: where auc.auction_header_id = p_auction_header_id
183: and neg.auction_header_id= auc.auction_header_id
184: and neg.user_id = l_user_id;
185:

Line 247: update pon_auction_headers_all

243: begin
244: l_auction_header_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'AUCTION_HEADER_ID');
247: update pon_auction_headers_all
248: set auction_status = 'CANCELLED'
249: where auction_header_id=l_auction_header_id;
250:
251: end UPDATE_DOC_TO_CANCELLED;

Line 285: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

281: l_timeout_factor number;
282: l_open_date_in_tz date;
283: l_close_date_in_tz date;
284: l_open_auction_now_flag varchar2(1);
285: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
286: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
287: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
289: l_round_number NUMBER;

Line 286: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

282: l_open_date_in_tz date;
283: l_close_date_in_tz date;
284: l_open_auction_now_flag varchar2(1);
285: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
286: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
287: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
289: l_round_number NUMBER;
290: l_amendment_number NUMBER;

Line 287: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;

283: l_close_date_in_tz date;
284: l_open_auction_now_flag varchar2(1);
285: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
286: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
287: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
289: l_round_number NUMBER;
290: l_amendment_number NUMBER;
291: l_auction_header_id_orig_amend NUMBER;

Line 288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;

284: l_open_auction_now_flag varchar2(1);
285: l_trading_partner_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
286: l_trading_partner_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
287: l_auction_start_date PON_AUCTION_HEADERS_ALL.OPEN_BIDDING_DATE%TYPE;
288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
289: l_round_number NUMBER;
290: l_amendment_number NUMBER;
291: l_auction_header_id_orig_amend NUMBER;
292: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

Line 292: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

288: l_auction_end_date PON_AUCTION_HEADERS_ALL.CLOSE_BIDDING_DATE%TYPE;
289: l_round_number NUMBER;
290: l_amendment_number NUMBER;
291: l_auction_header_id_orig_amend NUMBER;
292: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
293: l_review_changes_url VARCHAR2(2000);
294: l_preview_date DATE;
295: l_preview_date_in_tz DATE;
296: l_timezone1_disp VARCHAR2(240);

Line 308: from fnd_user fnd,pon_auction_headers_all pon

304: nvl(pon.open_auction_now_flag,'N') open_auction_now_flag,
305: pon.document_number, trading_partner_contact_id, trading_partner_name, trading_partner_contact_name,
306: open_bidding_date, close_bidding_date, nvl(auction_round_number, 1),
307: nvl(amendment_number, 0), auction_header_id_orig_amend, view_by_date
308: from fnd_user fnd,pon_auction_headers_all pon
309: where fnd.person_party_id = pon.trading_partner_contact_id and
310: pon.auction_header_id = p_auction_header_id and
311: rownum=1;
312:

Line 443: from pon_auction_headers_all auh, pon_auc_doctypes dt

439: avalue => l_creator_user_id);
440:
441: select dt.doctype_group_name
442: into l_doctype_group_name
443: from pon_auction_headers_all auh, pon_auc_doctypes dt
444: where auh.auction_header_id = p_auction_header_id
445: and auh.doctype_id = dt.doctype_id;
446:
447: l_msg_suffix := PON_AUCTION_PKG.GET_MESSAGE_SUFFIX (l_doctype_group_name);

Line 555: from pon_auction_headers_all

551: aname => 'NOTE_TO_APPROVERS',
552: avalue => p_note_to_approvers);
553: select document_number
554: into l_orig_document_number
555: from pon_auction_headers_all
556: where auction_header_id = l_auction_header_id_orig_amend;
557:
558: -- set notification subjects
559: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);

Line 601: UPDATE pon_auction_headers_all set

597: wf_engine.StartProcess (itemType => l_itemType,
598: itemKey => l_itemKey );
599:
600: /* Update Headers table */
601: UPDATE pon_auction_headers_all set
602: wf_approval_item_key = l_itemKey,
603: approval_status = 'INPROCESS'
604: WHERE auction_header_id = p_auction_header_id;
605:

Line 639: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;

635: l_note_to_approvers Varchar2(2000);
636: l_publish_auction_now_flag varchar2(1);
637: l_open_auction_now_flag varchar2(1);
638: l_reminder_date date;
639: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
640: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
641: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
642: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
643: l_auction_start_date DATE;

Line 640: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;

636: l_publish_auction_now_flag varchar2(1);
637: l_open_auction_now_flag varchar2(1);
638: l_reminder_date date;
639: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
640: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
641: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
642: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
643: l_auction_start_date DATE;
644: l_auction_end_date DATE;

Line 641: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

637: l_open_auction_now_flag varchar2(1);
638: l_reminder_date date;
639: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
640: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
641: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
642: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
643: l_auction_start_date DATE;
644: l_auction_end_date DATE;
645: l_timezone_dsp varchar2(100);

Line 642: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;

638: l_reminder_date date;
639: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
640: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
641: l_doc_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
642: l_preparer_tp_contact_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_NAME%TYPE;
643: l_auction_start_date DATE;
644: l_auction_end_date DATE;
645: l_timezone_dsp varchar2(100);
646: l_review_changes_url VARCHAR2(2000);

Line 647: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;

643: l_auction_start_date DATE;
644: l_auction_end_date DATE;
645: l_timezone_dsp varchar2(100);
646: l_review_changes_url VARCHAR2(2000);
647: l_orig_document_number PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE;
648: l_round_number NUMBER;
649: l_amendment_number NUMBER;
650: l_preview_date_in_tz DATE;
651: l_timezone1_disp varchar2(240);

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

663: trading_partner_contact_id auction_contact_id,
664: nvl(auc.publish_auction_now_flag,'N') publish_auction_now_flag,
665: nvl(auc.open_auction_now_flag,'N') open_auction_now_flag,
666: auc.auction_header_id_orig_amend
667: from pon_neg_team_members neg, pon_auction_headers_all auc, fnd_user u
668: where neg.auction_header_id = auc.auction_header_id and
669: auc.auction_header_id = p_auction_header_id
670: and neg.APPROVER_FLAG ='Y'
671: and u.user_id = neg.user_id;

Line 997: from pon_auction_headers_all

993: avalue => l_note_to_approvers);
994:
995: select document_number
996: into l_orig_document_number
997: from pon_auction_headers_all
998: where auction_header_id = r1.auction_header_id_orig_amend;
999:
1000: -- set notification subjects
1001: set_notification_subject(l_itemType, l_itemKey, l_msg_suffix, l_doc_number, l_orig_document_number, l_amendment_number, l_auction_title);

Line 1025: from pon_auction_headers_all auc,

1021: Begin
1022: begin
1023: select 'Y'
1024: into l_result
1025: from pon_auction_headers_all auc,
1026: pon_neg_team_members neg
1027: where auc.auction_header_id = neg.auction_header_id
1028: and auc.auction_header_id = p_auction_header_id
1029: and auc.approval_status = 'INPROCESS'

Line 1120: from pon_auction_headers_all

1116:
1117: /* Get the top process item key */
1118: Select wf_approval_item_key
1119: into l_top_process_itemKey
1120: from pon_auction_headers_all
1121: where auction_header_id = p_auctionHeaderId;
1122:
1123: if (p_decision = 'APPROVE') then
1124: Process_If_Doc_Approved(p_auctionHeaderId,l_top_process_itemKey);

Line 1209: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

1205: l_language_code varchar2(100);
1206: l_timezone varchar2(100);
1207: l_timezone_disp varchar2(100);
1208: l_oex_timezone varchar2(100);
1209: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1210: l_preview_date_in_tz DATE;
1211: l_timezone1_disp varchar2(240);
1212: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1213:

Line 1301: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;

1297: l_language_code varchar2(100);
1298: l_timezone varchar2(100);
1299: l_timezone_disp varchar2(100);
1300: l_oex_timezone varchar2(100);
1301: l_auction_contact_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_CONTACT_ID%TYPE;
1302: l_preview_date_in_tz DATE;
1303: l_timezone1_disp varchar2(240);
1304: l_preview_date_nspec FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
1305:

Line 1460: update pon_auction_headers_all

1456: * neg the lock might remain with the approver in case he
1457: * navigated to the review page. Bug 4777895.
1458: */
1459:
1460: update pon_auction_headers_all
1461: set approval_status = p_status,
1462: draft_locked = 'N',
1463: draft_locked_by = null,
1464: draft_locked_by_contact_id = null,