DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_WF_PUBLISH_S

Line 351: SELECT pon_auction_wf_publish_s.nextval

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:

Line 3811: SELECT pon_auction_wf_publish_s.nextval

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));

Line 6991: SELECT pon_auction_wf_publish_s.nextval

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:

Line 7425: SELECT pon_auction_wf_publish_s.nextval

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));

Line 8612: SELECT pon_auction_wf_publish_s.nextval

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:

Line 9280: SELECT pon_auction_wf_publish_s.nextval

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;

Line 10820: SELECT pon_auction_wf_publish_s.nextval

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;

Line 11222: SELECT pon_auction_wf_publish_s.nextval

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;