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 493: FROM fnd_user

489: l_counter NUMBER;
490:
491: CURSOR l_user_cur (p_user_name IN VARCHAR2) IS
492: SELECT user_id
493: FROM fnd_user
494: WHERE user_name = Upper(p_user_name);
495:
496: l_user_id NUMBER;
497:

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

513:
514: FOR l_rec IN l_cur LOOP
515:
516: if (l_rec.create_user_account = 'Y' and
517: FND_USER_PKG.TestUserName(Upper(l_rec.email_address)) = FND_USER_PKG.USER_SYNCHED) then
518: l_user_in_oid := 'Y';
519: else
520: l_user_in_oid := 'N';
521: end if;

Line 663: FROM pos_contact_requests pcr, fnd_user fu

659: )
660: IS
661: CURSOR l_cur IS
662: SELECT fu.user_name, fu.user_id
663: FROM pos_contact_requests pcr, fnd_user fu
664: WHERE pcr.mapping_id =
665: (SELECT mapping_id
666: FROM pos_supplier_mappings
667: WHERE supplier_reg_id = p_supplier_reg_id

Line 718: l_user_name fnd_user.user_name%TYPE;

714: IS
715: l_itemtype wf_items.item_type%TYPE;
716: l_itemkey wf_items.item_key%TYPE;
717: l_count NUMBER;
718: l_user_name fnd_user.user_name%TYPE;
719: l_user_id NUMBER;
720: BEGIN
721: get_reg_primary_user
722: (p_supplier_reg_id => p_supplier_reg_id,

Line 795: l_user_name fnd_user.user_name%TYPE;

791: l_method VARCHAR2(30);
792: l_vendor_id NUMBER;
793: l_vendor_party_id NUMBER;
794: l_username_pwds username_pwd_tbl;
795: l_user_name fnd_user.user_name%TYPE;
796: l_user_id NUMBER;
797:
798: CURSOR l_ptp_cur(p_party_id IN NUMBER) IS
799: SELECT party_tax_profile_id

Line 1161: l_receiver fnd_user.user_name%TYPE;

1157: l_step VARCHAR2(100);
1158: l_method VARCHAR2(30);
1159: l_itemtype wf_items.item_type%TYPE;
1160: l_itemkey wf_items.item_key%TYPE;
1161: l_receiver fnd_user.user_name%TYPE;
1162:
1163: l_supplier_reg_rec pos_supplier_registrations%ROWTYPE;
1164:
1165: BEGIN