DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on WF_DIRECTORY

Line 4219: WF_DIRECTORY.CreateAdHocRole(x_role_name,

4215: x_role_name := ('WF_PON_ROLE_'||to_char(x_auction_header_id)||'_'||to_char(x_sequence));
4216:
4217: x_progress := '021';
4218:
4219: WF_DIRECTORY.CreateAdHocRole(x_role_name,
4220: x_role_name,
4221: 'AMERICAN',
4222: 'AMERICA',
4223: 'Oracle Exchange Bidder '||to_char(x_auction_header_id),

Line 4256: l_users WF_DIRECTORY.UserTable;

4252: x_user_name VARCHAR2(100);
4253: x_auction_header_id NUMBER;
4254: x_progress VARCHAR2(3);
4255:
4256: l_users WF_DIRECTORY.UserTable;
4257:
4258: CURSOR suppliers IS
4259: select user_name
4260: from wf_user_roles

Line 4293: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

4289: FOR supplier IN suppliers LOOP
4290:
4291: x_user_name := supplier.user_name;
4292:
4293: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
4294: x_user_name);*/
4295: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
4296: if (x_user_name is NOT NULL) then
4297: string_to_userTable(x_user_name, l_users);

Line 4298: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

4294: x_user_name);*/
4295: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
4296: if (x_user_name is NOT NULL) then
4297: string_to_userTable(x_user_name, l_users);
4298: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
4299: l_users);
4300: end if;
4301:
4302: END LOOP;

Line 4341: l_users WF_DIRECTORY.UserTable;

4337: x_nls_territory VARCHAR2(60);
4338:
4339: l_auctioneer_nls_language fnd_languages.nls_language%TYPE;
4340: l_auctioneer_nls_territory fnd_territories.nls_territory%TYPE;
4341: l_users WF_DIRECTORY.UserTable;
4342:
4343: CURSOR new_bidders IS
4344: select pbp.trading_partner_contact_name,
4345: pbp.trading_partner_contact_id,

Line 4453: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

4449: -- Added for the bug#8847938 to remove the space as delimitter in user name
4450: if (x_user_name is NOT NULL) then
4451: string_to_userTable(x_user_name, l_users);
4452:
4453: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
4454: x_user_name);*/
4455:
4456: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
4457: l_users);

Line 4456: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

4452:
4453: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
4454: x_user_name);*/
4455:
4456: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
4457: l_users);
4458: end if;
4459:
4460: end if;

Line 4522: WF_DIRECTORY.CreateAdHocUser(x_user_name,

4518: x_progress := '022';
4519:
4520: -- Create an adhoc user for the additional contact
4521:
4522: WF_DIRECTORY.CreateAdHocUser(x_user_name,
4523: bidder.additional_contact_email,
4524: x_nls_language,
4525: x_nls_territory,
4526: 'Oracle Exchange Additional Bidder '||to_char(x_auction_header_id),

Line 4541: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

4537: AND vendor_site_id = bidder.vendor_site_id;
4538:
4539: -- Also insert into the role
4540: -- Added for the bug#8847938 to remove the space as delimitter in user name
4541: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
4542: x_user_name);*/
4543: if (x_user_name is NOT NULL) then
4544: string_to_userTable(x_user_name, l_users);
4545:

Line 4546: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

4542: x_user_name);*/
4543: if (x_user_name is NOT NULL) then
4544: string_to_userTable(x_user_name, l_users);
4545:
4546: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
4547: l_users);
4548: end if;
4549: end if; -- (bidder.additional_contact_email IS NOT NULL)
4550:

Line 4568: WF_DIRECTORY.CreateAdHocUser(x_user_name,

4564: x_user_name := ('WF_PON_ADD_USER_'||to_char(x_sequence));
4565: x_progress := '022_REQ';
4566:
4567: -- Create an adhoc user for the requested_supplier
4568: WF_DIRECTORY.CreateAdHocUser(x_user_name,
4569: x_user_name,
4570: x_nls_language,
4571: x_nls_territory,
4572: 'Oracle Exchange Requested Bidder'||to_char(x_auction_header_id),

Line 4589: --WF_DIRECTORY.AddUsersToAdHocRole(x_role_name, x_user_name);

4585:
4586: x_progress := '024_REQ';
4587:
4588: -- Also insert into the role
4589: --WF_DIRECTORY.AddUsersToAdHocRole(x_role_name, x_user_name);
4590:
4591: -- Added for the bug#8847938 to remove the space as delimitter in user name
4592: if (x_user_name is NOT NULL) then
4593: string_to_userTable(x_user_name, l_users);

Line 4595: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

4591: -- Added for the bug#8847938 to remove the space as delimitter in user name
4592: if (x_user_name is NOT NULL) then
4593: string_to_userTable(x_user_name, l_users);
4594:
4595: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
4596: l_users);
4597: end if;
4598:
4599: end if; --} tp_id == null and requested_supplier_contact_id != null

Line 4923: l_users WF_DIRECTORY.UserTable;

4919: x_user_orig_system_id NUMBER := 0;
4920: x_role_orig_system VARCHAR2(30) := 'WF_LOCAL_ROLES';
4921: x_role_orig_system_id NUMBER := 0;
4922: x_bidder_count NUMBER;
4923: l_users WF_DIRECTORY.UserTable;
4924:
4925: BEGIN
4926: x_progress := '010';
4927:

Line 4935: /*WF_DIRECTORY.AddUsersToAdHocRole(p_role_name,

4931: where role_name = p_role_name
4932: and user_name = p_user_name;
4933:
4934: if (x_bidder_count < 1) then
4935: /*WF_DIRECTORY.AddUsersToAdHocRole(p_role_name,
4936: p_user_name);*/
4937: -- -- Added for the bug#8847938 to remove the space as delimitter in user name
4938: if (p_user_name is NOT NULL) then
4939: string_to_userTable(p_user_name, l_users);

Line 4942: WF_DIRECTORY.AddUsersToAdHocRole2(p_role_name,

4938: if (p_user_name is NOT NULL) then
4939: string_to_userTable(p_user_name, l_users);
4940:
4941:
4942: WF_DIRECTORY.AddUsersToAdHocRole2(p_role_name,
4943: l_users);
4944: end if;
4945: end if;
4946: END;

Line 7213: l_users WF_DIRECTORY.UserTable;

7209: x_rs_user_name VARCHAR2(100);
7210: x_nls_rs_language VARCHAR2(60);
7211: x_nls_rs_territory VARCHAR2(30);
7212:
7213: l_users WF_DIRECTORY.UserTable;
7214:
7215: cursor newInvitees is
7216: select
7217: trading_partner_contact_name,

Line 7357: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

7353: if (x_bidder_count < 1) then
7354:
7355: -- Add new user and send notification.
7356:
7357: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
7358: x_user_name);*/
7359: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7360: if (x_user_name is NOT NULL) then
7361: string_to_userTable(x_user_name, l_users);

Line 7362: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

7358: x_user_name);*/
7359: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7360: if (x_user_name is NOT NULL) then
7361: string_to_userTable(x_user_name, l_users);
7362: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
7363: l_users);
7364: end if;
7365: end if; -- Bug 3824928: Added end if
7366:

Line 7739: WF_DIRECTORY.CreateAdHocUser(x_additional_user_name,

7735: from fnd_territories
7736: where territory_code = x_territory_code;
7737:
7738:
7739: WF_DIRECTORY.CreateAdHocUser(x_additional_user_name,
7740: x_additional_user_name,
7741: x_nls_addnl_language,
7742: x_nls_addnl_territory,
7743: 'Oracle Exchange Additional Bidder '||to_char(x_auction_header_id),

Line 7750: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

7746: null,
7747: 'ACTIVE',
7748: null);
7749:
7750: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
7751: x_additional_user_name);*/
7752: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7753: if (x_additional_user_name is NOT NULL) then
7754: string_to_userTable(x_additional_user_name, l_users);

Line 7755: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

7751: x_additional_user_name);*/
7752: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7753: if (x_additional_user_name is NOT NULL) then
7754: string_to_userTable(x_additional_user_name, l_users);
7755: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
7756: l_users);
7757: end if;
7758:
7759: -- Bug 3709564

Line 7803: WF_DIRECTORY.CreateAdHocUser(x_rs_user_name,

7799: avalue => x_ack_part_url_supplier);
7800:
7801: -- create user
7802:
7803: WF_DIRECTORY.CreateAdHocUser(x_rs_user_name,
7804: x_rs_user_name,
7805: x_nls_rs_language,
7806: x_nls_rs_territory,
7807: 'Oracle Exchange Requested Bidder'||to_char(x_auction_header_id),

Line 7814: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,

7810: null,
7811: 'ACTIVE',
7812: null);
7813:
7814: /*WF_DIRECTORY.AddUsersToAdHocRole(x_role_name,
7815: x_rs_user_name);*/
7816: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7817: if ( x_rs_user_name is NOT NULL) then
7818: string_to_userTable( x_rs_user_name, l_users);

Line 7819: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,

7815: x_rs_user_name);*/
7816: -- Modified from AddUsersToAdHocRole to AddUsersToAdHocRole2 for bug 11067311
7817: if ( x_rs_user_name is NOT NULL) then
7818: string_to_userTable( x_rs_user_name, l_users);
7819: WF_DIRECTORY.AddUsersToAdHocRole2(x_role_name,
7820: l_users);
7821: end if;
7822:
7823: UPDATE pon_bidding_parties SET

Line 17753: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)

17749:
17750: -- Added for the bug#8847938 to remove the space as delimitter in user name
17751:
17752: procedure String_To_UserTable (p_UserList in VARCHAR2,
17753: p_UserTable out NOCOPY WF_DIRECTORY.UserTable)
17754: is
17755:
17756: c1 pls_integer;
17757: u1 pls_integer := 0;