DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_WF_PUBLISH_S

Line 328: SELECT pon_auction_wf_publish_s.nextval

324: --
325: -- Get next value in sequence for itemkey
326: --
327:
328: SELECT pon_auction_wf_publish_s.nextval
329: INTO x_sequence
330: FROM dual;
331:
332:

Line 3290: SELECT pon_auction_wf_publish_s.nextval

3286:
3287: -- this bidder has not been invited to the new round
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));

Line 6389: SELECT pon_auction_wf_publish_s.nextval

6385: --
6386: -- Get next value in sequence for itemkey
6387: --
6388:
6389: SELECT pon_auction_wf_publish_s.nextval
6390: INTO x_sequence
6391: FROM dual;
6392:
6393:

Line 6810: SELECT pon_auction_wf_publish_s.nextval

6806:
6807: -- this is needed here because of a bug in wf (fixed in 2.6)
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));

Line 7933: SELECT pon_auction_wf_publish_s.nextval

7929: x_tp_id NUMBER;
7930:
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:

Line 8566: SELECT pon_auction_wf_publish_s.nextval

8562:
8563: SET_SESSION_LANGUAGE(null, x_language_code);
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;

Line 9984: SELECT pon_auction_wf_publish_s.nextval

9980: END IF;
9981:
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;

Line 10386: SELECT pon_auction_wf_publish_s.nextval

10382: END IF;
10383:
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;