APPS.PON_AUCTION_PKG dependencies on WF_LOCAL_USER_ROLES

Line 3643: wf_local_user_roles wlur

3639: pbp.trading_partner_name party_name,
3640: DECODE(pbp.vendor_site_code, '-1', NULL, pbp.vendor_site_code) vendor_site_code,
3641: pbp.vendor_site_id
3642: FROM pon_bidding_parties pbp,
3643: wf_local_user_roles wlur
3644: WHERE pbp.auction_header_id = x_doc_header_id_prev_round
3645: AND wlur.role_name = x_role_name
3646: AND wlur.user_name = pbp.wf_user_name
3647: AND pbp.trading_partner_id is not null --leave out requested suppliers

Line 3656: FROM wf_local_user_roles wlur,

3652: pbh.trading_partner_id party_id,
3653: pbh.trading_partner_name party_name,
3654: DECODE(pbh.vendor_site_code, '-1', NULL, pbh.vendor_site_code) vendor_site_code,
3655: pbh.vendor_site_id
3656: FROM wf_local_user_roles wlur,
3657: pon_bid_headers pbh
3658: WHERE wlur.role_name = x_role_name
3659: AND x_doc_header_id_prev_round = pbh.auction_header_id
3660: AND wlur.user_name = pbh.trading_partner_contact_name(+);

Line 4444: from wf_local_user_roles

4440: end;
4441:
4442: select count(*)
4443: into x_bidder_count
4444: from wf_local_user_roles
4445: where role_name = x_role_name
4446: and user_name = x_user_name;
4447:
4448: if (x_bidder_count < 1) then

Line 4930: from wf_local_user_roles

4926: x_progress := '010';
4927:
4928: select count(*)
4929: into x_bidder_count
4930: from wf_local_user_roles
4931: where role_name = p_role_name
4932: and user_name = p_user_name;
4933:
4934: if (x_bidder_count < 1) then

Line 7348: from wf_local_user_roles

7344: -- check if the contact is in the role - if not this is a new invitee
7345: x_user_name := GET_USER_NAME(x_person_party_id);
7346:
7347: select count(*) into x_bidder_count
7348: from wf_local_user_roles
7349: where role_name = x_role_name
7350: and user_name = x_user_name;
7351:
7352:

Line 7681: from wf_local_user_roles

7677: -- not this is the additional contact of a new invitee
7678:
7679:
7680: select count(*) into x_bidder_count
7681: from wf_local_user_roles
7682: where role_name = x_role_name
7683: and user_name = bidder.wf_user_name;
7684:
7685: if (x_bidder_count < 1) then

Line 7780: FROM wf_local_user_roles

7776: INTO x_sequence
7777: FROM dual;
7778:
7779: SELECT count(*) INTO x_bidder_count
7780: FROM wf_local_user_roles
7781: WHERE role_name = x_role_name
7782: AND user_name = bidder.wf_user_name;
7783:
7784: IF (x_bidder_count < 1) THEN --{