[Home] [Help]
326: --
327:
328: SELECT pon_auction_wf_publish_s.nextval
329: INTO x_sequence
330: FROM dual;
331:
332:
333: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
334:
1012: -- Get next value in sequence for itemkey
1013: --
1014: SELECT pon_auction_wf_s.nextval
1015: INTO x_sequence
1016: FROM dual;
1017: -- get the contact name and auction type
1018: -- to fix bug 2797825, overwritting reminder_date, which is null up to
1019: -- this point
1020: open c1_auction_info(x_language_code);
1449: -- Get next value in sequence for itemkey
1450: --
1451: SELECT pon_auction_wf_bid_s.nextval
1452: INTO x_sequence
1453: FROM dual;
1454:
1455: x_progress := '020';
1456:
1457:
1674: --
1675:
1676: SELECT pon_auction_wf_dqbid_s.nextval
1677: INTO x_sequence
1678: FROM dual;
1679:
1680: -- lxchen why???
1681: --
1682: -- Get the exchange's time zone
2036: -- Get next value in sequence for itemkey
2037: --
2038: SELECT pon_auction_wf_rtbid_s.nextval
2039: INTO x_sequence
2040: FROM dual;
2041:
2042: x_progress := '020';
2043:
2044:
2233: --
2234:
2235: SELECT pon_auction_wf_acbid_s.nextval
2236: INTO x_sequence
2237: FROM dual;
2238:
2239: --
2240: -- get the contact name and auction type
2241: --
3288: -- Get next value in sequence for itemkey
3289:
3290: SELECT pon_auction_wf_publish_s.nextval
3291: INTO x_sequence
3292: FROM dual;
3293:
3294: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
3295:
3296: wf_engine.CreateProcess(itemtype => x_itemtype,
3651: --
3652:
3653: SELECT pon_auction_wf_role_s.nextval
3654: INTO x_sequence
3655: FROM dual;
3656:
3657: x_role_name := ('WF_PON_ROLE_'||to_char(x_auction_header_id)||'_'||to_char(x_sequence));
3658:
3659: x_progress := '021';
3937: END IF;--}
3938:
3939: SELECT pon_auction_wf_bidder_s.nextval
3940: INTO x_sequence
3941: FROM dual;
3942:
3943: x_user_name := ('WF_PON_ADD_USER_'||to_char(x_sequence));
3944:
3945: x_progress := '022';
3980:
3981: -- Get next bidder from sequence
3982: SELECT pon_auction_wf_bidder_s.nextval
3983: INTO x_sequence
3984: FROM dual;
3985:
3986: x_user_name := ('WF_PON_ADD_USER_'||to_char(x_sequence));
3987: x_progress := '022_REQ';
3988:
6387: --
6388:
6389: SELECT pon_auction_wf_publish_s.nextval
6390: INTO x_sequence
6391: FROM dual;
6392:
6393:
6394: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
6395:
6808: UNSET_SESSION_LANGUAGE;
6809:
6810: SELECT pon_auction_wf_publish_s.nextval
6811: INTO x_sequence
6812: FROM dual;
6813:
6814: t_itemkey := (x_itemkey||'-'||to_char(x_sequence));
6815:
6816: wf_engine.CreateProcess(itemtype => t_itemtype,
7033: if bidder.additional_contact_email is not NULL THEN --{
7034:
7035: SELECT pon_auction_wf_bidder_s.nextval
7036: INTO x_sequence
7037: FROM dual;
7038: -- Bug 3824928 - check if the additional contact is in the role - if
7039: -- not this is the additional contact of a new invitee
7040:
7041:
7129: if (l_requested_supplier and bidder.rs_contact_email is not NULL) THEN
7130: -- {
7131: SELECT pon_auction_wf_bidder_s.nextval
7132: INTO x_sequence
7133: FROM dual;
7134:
7135: SELECT count(*) INTO x_bidder_count
7136: FROM wf_local_user_roles
7137: WHERE role_name = x_role_name
7525: l_debug_level := '0';
7526: end;
7527:
7528: select to_char(PON_PO_WF_ITEMKEY_S.NEXTVAL)
7529: into l_seq from sys.dual;
7530: */
7531: -- Hardcoded sequence number not acceptable
7532: l_seq := 9999;
7533: l_itemkey := to_char (document_id)|| '-' || l_seq;
7596: end if;
7597: l_doc_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
7598: 'ECX_DOCUMENT_ID');
7599: /* sequence number hardcoded
7600: select PON_PO_WF_ITEMKEY_S.nextval into l_wf_item_seq from dual;
7601: */
7602: l_wf_item_seq := 9999;
7603:
7604: l_xml_event_key := to_char(l_doc_id) || '-' || to_char(l_wf_item_seq);
7931: BEGIN
7932:
7933: SELECT pon_auction_wf_publish_s.nextval
7934: INTO x_sequence
7935: FROM dual;
7936: x_itemkey := (p_itemkey||'-'||to_char(x_sequence));
7937:
7938: wf_engine.CreateProcess(itemtype => x_itemtype,
7939: itemkey => x_itemkey,
8564: END IF;
8565:
8566: SELECT pon_auction_wf_publish_s.nextval
8567: INTO x_sequence
8568: FROM dual;
8569:
8570: x_tp_display_name := bidder.my_user_display_name;
8571:
8572: x_itemkey := (itemkey||'-'||to_char(x_sequence));
9768: x_req_backed := 'Y';
9769:
9770: SELECT 'N'
9771: INTO x_req_backed
9772: FROM dual
9773: WHERE EXISTS (SELECT 1
9774: FROM pon_auction_item_prices_all al
9775: WHERE al.auction_header_id = p_auction_header_id
9776: AND al.group_type NOT IN ('GROUP','LOT_LINE')
9982: x_itemtype := 'PONAUCT';
9983:
9984: SELECT pon_auction_wf_publish_s.nextval
9985: INTO l_sequence
9986: FROM dual;
9987:
9988: x_itemkey := p_auction_header_id||'-'|| l_sequence;
9989:
9990: wf_engine.CreateProcess(itemtype => x_itemtype,
10384: x_itemtype := 'PONAUCT';
10385:
10386: SELECT pon_auction_wf_publish_s.nextval
10387: INTO l_sequence
10388: FROM dual;
10389:
10390: x_itemkey := p_auction_header_id||'-'|| l_sequence;
10391:
10392: wf_engine.CreateProcess(itemtype => x_itemtype,
12579: ), 'Y', 'N')
12580: INTO
12581: x_all_site_bid_on
12582: FROM
12583: DUAL;
12584:
12585: SELECT
12586: DECODE( nvl(v_is_paused, 'N'), 'Y', 'Y', nvl2(v_staggered_closing_interval, 'S', 'N'))
12587: INTO
12586: DECODE( nvl(v_is_paused, 'N'), 'Y', 'Y', nvl2(v_staggered_closing_interval, 'S', 'N'))
12587: INTO
12588: x_is_paused
12589: FROM
12590: DUAL;
12591:
12592: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12593: FND_LOG.string (log_level => FND_LOG.level_statement,
12594: module => g_module_prefix || '.get_negotiation_details',
13021:
13022: -- get unique item key by a combination of sequence and bid number.
13023: SELECT pon_auction_wf_dqbid_s.nextval
13024: INTO x_item_key
13025: FROM dual;
13026: x_item_key := bidder.bid_number || '-' || x_item_key;
13027:
13028: -- bidder name: this is the person who gets the notification
13029: l_bidder_name := bidder.trading_partner_contact_name;