347: --
348: -- Get next value in sequence for itemkey
349: --
350:
351: SELECT pon_auction_wf_publish_s.nextval
352: INTO x_sequence
353: FROM dual;
354:
355:
3807:
3808: -- this bidder has not been invited to the new round
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));
6987: --
6988: -- Get next value in sequence for itemkey
6989: --
6990:
6991: SELECT pon_auction_wf_publish_s.nextval
6992: INTO x_sequence
6993: FROM dual;
6994:
6995:
7421:
7422: -- this is needed here because of a bug in wf (fixed in 2.6)
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));
8608: x_supplier_exampt_count NUMBER; --choli
8609: x_exempt_flag VARCHAR2(1); --choli
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:
9276: --SET_SESSION_LANGUAGE(null, x_language_code);
9277: --END IF;
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;
10816: END IF;
10817:
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;
11218: END IF;
11219:
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;