DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_AUCTION_WF_BIDDER_S

Line 3939: SELECT pon_auction_wf_bidder_s.nextval

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

Line 3982: SELECT pon_auction_wf_bidder_s.nextval

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

Line 7035: SELECT pon_auction_wf_bidder_s.nextval

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

Line 7131: SELECT pon_auction_wf_bidder_s.nextval

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