APPS.PON_AUCTION_PKG dependencies on WF_LOCAL_USER_ROLES

Line 3133: wf_local_user_roles wlur

3129: pbp.trading_partner_name party_name,
3130: DECODE(pbp.vendor_site_code, '-1', NULL, pbp.vendor_site_code) vendor_site_code,
3131: pbp.vendor_site_id
3132: FROM pon_bidding_parties pbp,
3133: wf_local_user_roles wlur
3134: WHERE pbp.auction_header_id = x_doc_header_id_prev_round
3135: AND wlur.role_name = x_role_name
3136: AND wlur.user_name = pbp.wf_user_name
3137: AND pbp.trading_partner_id is not null --leave out requested suppliers

Line 3146: FROM wf_local_user_roles wlur,

3142: pbh.trading_partner_id party_id,
3143: pbh.trading_partner_name party_name,
3144: DECODE(pbh.vendor_site_code, '-1', NULL, pbh.vendor_site_code) vendor_site_code,
3145: pbh.vendor_site_id
3146: FROM wf_local_user_roles wlur,
3147: pon_bid_headers pbh
3148: WHERE wlur.role_name = x_role_name
3149: AND x_doc_header_id_prev_round = pbh.auction_header_id
3150: AND wlur.user_name = pbh.trading_partner_contact_name(+);

Line 3878: from wf_local_user_roles

3874: end;
3875:
3876: select count(*)
3877: into x_bidder_count
3878: from wf_local_user_roles
3879: where role_name = x_role_name
3880: and user_name = x_user_name;
3881:
3882: if (x_bidder_count < 1) then

Line 4343: from wf_local_user_roles

4339: x_progress := '010';
4340:
4341: select count(*)
4342: into x_bidder_count
4343: from wf_local_user_roles
4344: where role_name = p_role_name
4345: and user_name = p_user_name;
4346:
4347: if (x_bidder_count < 1) then

Line 6739: from wf_local_user_roles

6735: -- check if the contact is in the role - if not this is a new invitee
6736: x_user_name := GET_USER_NAME(x_person_party_id);
6737:
6738: select count(*) into x_bidder_count
6739: from wf_local_user_roles
6740: where role_name = x_role_name
6741: and user_name = x_user_name;
6742:
6743:

Line 7043: from wf_local_user_roles

7039: -- not this is the additional contact of a new invitee
7040:
7041:
7042: select count(*) into x_bidder_count
7043: from wf_local_user_roles
7044: where role_name = x_role_name
7045: and user_name = bidder.wf_user_name;
7046:
7047: if (x_bidder_count < 1) then

Line 7136: FROM wf_local_user_roles

7132: INTO x_sequence
7133: FROM dual;
7134:
7135: SELECT count(*) INTO x_bidder_count
7136: FROM wf_local_user_roles
7137: WHERE role_name = x_role_name
7138: AND user_name = bidder.wf_user_name;
7139:
7140: IF (x_bidder_count < 1) THEN --{