DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_WF_BIDDER_S

Line 4512: SELECT pon_auction_wf_bidder_s.nextval

4508: x_nls_language := l_auctioneer_nls_language;
4509: x_nls_territory:= l_auctioneer_nls_territory;
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));

Line 4560: SELECT pon_auction_wf_bidder_s.nextval

4556: x_nls_language := l_auctioneer_nls_language;
4557: x_nls_territory:= l_auctioneer_nls_territory;
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));

Line 7673: SELECT pon_auction_wf_bidder_s.nextval

7669: -- Bug 3824928: Checking if additional_contact_email is not null
7670:
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

Line 7775: SELECT pon_auction_wf_bidder_s.nextval

7771:
7772: -- create adhoc user for this rs contact
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