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_PKG dependencies on DUAL

Line 353: FROM dual;

349: --
350:
351: SELECT pon_auction_wf_publish_s.nextval
352: INTO x_sequence
353: FROM dual;
354:
355:
356: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
357:

Line 1155: FROM dual;

1151: --
1152:
1153: SELECT pon_auction_wf_acbid_s.nextval
1154: INTO x_sequence
1155: FROM dual;
1156:
1157: --
1158: -- get the contact name and auction type
1159: --

Line 1461: FROM dual;

1457: -- Get next value in sequence for itemkey
1458: --
1459: SELECT pon_auction_wf_s.nextval
1460: INTO x_sequence
1461: FROM dual;
1462: -- get the contact name and auction type
1463: -- to fix bug 2797825, overwritting reminder_date, which is null up to
1464: -- this point
1465: open c1_auction_info(x_language_code);

Line 1839: from dual;

1835: */
1836: BEGIN
1837: select decode(PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(p_auction_header_id), 1, 'Y', 'N')
1838: into x_is_doc_federal
1839: from dual;
1840:
1841: wf_engine.SetItemAttrText(itemtype => x_itemtype
1842: ,itemkey => x_itemkey
1843: ,aname => 'DOCUMENT_FEDERAL'

Line 1915: FROM dual;

1911: -- Get next value in sequence for itemkey
1912: --
1913: SELECT pon_auction_wf_bid_s.nextval
1914: INTO x_sequence
1915: FROM dual;
1916:
1917: x_progress := '020';
1918:
1919:

Line 2140: FROM dual;

2136: --
2137:
2138: SELECT pon_auction_wf_dqbid_s.nextval
2139: INTO x_sequence
2140: FROM dual;
2141:
2142: -- lxchen why???
2143: --
2144: -- Get the exchange's time zone

Line 2509: FROM dual;

2505: -- Get next value in sequence for itemkey
2506: --
2507: SELECT pon_auction_wf_rtbid_s.nextval
2508: INTO x_sequence
2509: FROM dual;
2510:
2511: x_progress := '020';
2512:
2513:

Line 2717: FROM dual;

2713: --
2714:
2715: SELECT pon_auction_wf_acbid_s.nextval
2716: INTO x_sequence
2717: FROM dual;
2718:
2719: --
2720: -- get the contact name and auction type
2721: --

Line 3813: FROM dual;

3809: -- Get next value in sequence for itemkey
3810:
3811: SELECT pon_auction_wf_publish_s.nextval
3812: INTO x_sequence
3813: FROM dual;
3814:
3815: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
3816:
3817: wf_engine.CreateProcess(itemtype => x_itemtype,

Line 4213: FROM dual;

4209: --
4210:
4211: SELECT pon_auction_wf_role_s.nextval
4212: INTO x_sequence
4213: FROM dual;
4214:
4215: x_role_name := ('WF_PON_ROLE_'||to_char(x_auction_header_id)||'_'||to_char(x_sequence));
4216:
4217: x_progress := '021';

Line 4514: FROM dual;

4510: END IF;--}
4511:
4512: SELECT pon_auction_wf_bidder_s.nextval
4513: INTO x_sequence
4514: FROM dual;
4515:
4516: x_user_name := ('WF_PON_ADD_USER_'||to_char(x_sequence));
4517:
4518: x_progress := '022';

Line 4562: FROM dual;

4558:
4559: -- Get next bidder from sequence
4560: SELECT pon_auction_wf_bidder_s.nextval
4561: INTO x_sequence
4562: FROM dual;
4563:
4564: x_user_name := ('WF_PON_ADD_USER_'||to_char(x_sequence));
4565: x_progress := '022_REQ';
4566:

Line 6993: FROM dual;

6989: --
6990:
6991: SELECT pon_auction_wf_publish_s.nextval
6992: INTO x_sequence
6993: FROM dual;
6994:
6995:
6996: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
6997:

Line 7427: FROM dual;

7423: UNSET_SESSION_LANGUAGE;
7424:
7425: SELECT pon_auction_wf_publish_s.nextval
7426: INTO x_sequence
7427: FROM dual;
7428:
7429: t_itemkey := (x_itemkey||'-'||to_char(x_sequence));
7430:
7431: wf_engine.CreateProcess(itemtype => t_itemtype,

Line 7675: FROM dual;

7671: if bidder.additional_contact_email is not NULL THEN --{
7672:
7673: SELECT pon_auction_wf_bidder_s.nextval
7674: INTO x_sequence
7675: FROM dual;
7676: -- Bug 3824928 - check if the additional contact is in the role - if
7677: -- not this is the additional contact of a new invitee
7678:
7679:

Line 7777: FROM dual;

7773: if (l_requested_supplier and bidder.rs_contact_email is not NULL) THEN
7774: -- {
7775: SELECT pon_auction_wf_bidder_s.nextval
7776: INTO x_sequence
7777: FROM dual;
7778:
7779: SELECT count(*) INTO x_bidder_count
7780: FROM wf_local_user_roles
7781: WHERE role_name = x_role_name

Line 8207: into l_seq from sys.dual;

8203: l_debug_level := '0';
8204: end;
8205:
8206: select to_char(PON_PO_WF_ITEMKEY_S.NEXTVAL)
8207: into l_seq from sys.dual;
8208: */
8209: -- Hardcoded sequence number not acceptable
8210: l_seq := 9999;
8211: l_itemkey := to_char (document_id)|| '-' || l_seq;

Line 8278: select PON_PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;

8274: end if;
8275: l_doc_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
8276: 'ECX_DOCUMENT_ID');
8277: /* sequence number hardcoded
8278: select PON_PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
8279: */
8280: l_wf_item_seq := 9999;
8281:
8282: l_xml_event_key := to_char(l_doc_id) || '-' || to_char(l_wf_item_seq);

Line 8614: FROM dual;

8610: BEGIN
8611:
8612: SELECT pon_auction_wf_publish_s.nextval
8613: INTO x_sequence
8614: FROM dual;
8615: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
8616:
8617: wf_engine.CreateProcess(itemtype => x_itemtype,
8618: itemkey => x_itemkey,

Line 9282: FROM dual;

9278: UNSET_SESSION_LANGUAGE;
9279:
9280: SELECT pon_auction_wf_publish_s.nextval
9281: INTO x_sequence
9282: FROM dual;
9283:
9284: x_tp_display_name := bidder.my_user_display_name;
9285:
9286: x_itemkey := (itemkey||'-'||to_char(x_sequence));

Line 9805: AND clm_base_line_num IS NULL),-1) INTO l_requisition_line_id FROM dual ;

9801: SELECT Nvl((SELECT REQUISITION_LINE_ID FROM po_requisition_lines_all
9802: WHERE auction_header_id = x_old_negotiation_id
9803: AND auction_line_number = rec.line_number
9804: AND group_line_id IS NULL
9805: AND clm_base_line_num IS NULL),-1) INTO l_requisition_line_id FROM dual ;
9806:
9807:
9808: /* if Line is Clin then make complete structure to return the pool */
9809:

Line 10608: FROM dual

10604: x_req_backed := 'Y';
10605:
10606: SELECT 'N'
10607: INTO x_req_backed
10608: FROM dual
10609: WHERE EXISTS (SELECT 1
10610: FROM pon_auction_item_prices_all al
10611: WHERE al.auction_header_id = p_auction_header_id
10612: AND al.group_type NOT IN ('GROUP','LOT_LINE')

Line 10822: FROM dual;

10818: x_itemtype := 'PONAUCT';
10819:
10820: SELECT pon_auction_wf_publish_s.nextval
10821: INTO l_sequence
10822: FROM dual;
10823:
10824: x_itemkey := p_auction_header_id||'-'|| l_sequence;
10825:
10826: wf_engine.CreateProcess(itemtype => x_itemtype,

Line 11224: FROM dual;

11220: x_itemtype := 'PONAUCT';
11221:
11222: SELECT pon_auction_wf_publish_s.nextval
11223: INTO l_sequence
11224: FROM dual;
11225:
11226: x_itemkey := p_auction_header_id||'-'|| l_sequence;
11227:
11228: wf_engine.CreateProcess(itemtype => x_itemtype,

Line 13440: DUAL;

13436: ), 'Y', 'N')
13437: INTO
13438: x_all_site_bid_on
13439: FROM
13440: DUAL;
13441:
13442: SELECT
13443: DECODE( nvl(v_is_paused, 'N'), 'Y', 'Y', nvl2(v_staggered_closing_interval, 'S', 'N'))
13444: INTO

Line 13447: DUAL;

13443: DECODE( nvl(v_is_paused, 'N'), 'Y', 'Y', nvl2(v_staggered_closing_interval, 'S', 'N'))
13444: INTO
13445: x_is_paused
13446: FROM
13447: DUAL;
13448:
13449: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13450: FND_LOG.string (log_level => FND_LOG.level_statement,
13451: module => g_module_prefix || '.get_negotiation_details',

Line 13884: FROM dual;

13880:
13881: -- get unique item key by a combination of sequence and bid number.
13882: SELECT pon_auction_wf_dqbid_s.nextval
13883: INTO x_item_key
13884: FROM dual;
13885: x_item_key := bidder.bid_number || '-' || x_item_key;
13886:
13887: -- bidder name: this is the person who gets the notification
13888: l_bidder_name := bidder.trading_partner_contact_name;