APPS.POS_VENDOR_REG_PKG dependencies on FND_USER

Line 7: (user_name fnd_user.user_name%TYPE,

3:
4: g_module VARCHAR2(30) := 'POS_VENDOR_REG_PKG';
5:
6: TYPE username_pwd_rec IS RECORD
7: (user_name fnd_user.user_name%TYPE,
8: password VARCHAR2(200),
9: exist_in_oid VARCHAR2(1)
10: );
11:

Line 576: FROM fnd_user

572: l_counter NUMBER;
573:
574: CURSOR l_user_cur (p_user_name IN VARCHAR2) IS
575: SELECT user_id
576: FROM fnd_user
577: WHERE user_name = Upper(p_user_name);
578:
579: l_user_id NUMBER;
580:

Line 600: FND_USER_PKG.TestUserName(Upper(l_rec.email_address)) = FND_USER_PKG.USER_SYNCHED) then

596:
597: FOR l_rec IN l_cur LOOP
598:
599: if (l_rec.create_user_account = 'Y' and
600: FND_USER_PKG.TestUserName(Upper(l_rec.email_address)) = FND_USER_PKG.USER_SYNCHED) then
601: l_user_in_oid := 'Y';
602: else
603: l_user_in_oid := 'N';
604: end if;

Line 746: FROM pos_contact_requests pcr, fnd_user fu

742: )
743: IS
744: CURSOR l_cur IS
745: SELECT fu.user_name, fu.user_id
746: FROM pos_contact_requests pcr, fnd_user fu
747: WHERE pcr.mapping_id =
748: (SELECT mapping_id
749: FROM pos_supplier_mappings
750: WHERE supplier_reg_id = p_supplier_reg_id

Line 815: l_user_name fnd_user.user_name%TYPE;

811: IS
812: l_itemtype wf_items.item_type%TYPE;
813: l_itemkey wf_items.item_key%TYPE;
814: l_count NUMBER;
815: l_user_name fnd_user.user_name%TYPE;
816: l_user_id NUMBER;
817: BEGIN
818: get_reg_primary_user
819: (p_supplier_reg_id => p_supplier_reg_id,

Line 984: l_user_name fnd_user.user_name%TYPE;

980: l_method VARCHAR2(30);
981: l_vendor_id NUMBER;
982: l_vendor_party_id NUMBER;
983: l_username_pwds username_pwd_tbl;
984: l_user_name fnd_user.user_name%TYPE;
985: l_user_id NUMBER;
986:
987: CURSOR l_ptp_cur(p_party_id IN NUMBER) IS
988: SELECT party_tax_profile_id

Line 1376: l_receiver fnd_user.user_name%TYPE;

1372: l_step VARCHAR2(100);
1373: l_method VARCHAR2(30);
1374: l_itemtype wf_items.item_type%TYPE;
1375: l_itemkey wf_items.item_key%TYPE;
1376: l_receiver fnd_user.user_name%TYPE;
1377:
1378: l_party_usages number := 0 ;
1379:
1380: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;