APPS.IBE_PAYMENT_INT_PVT dependencies on FND_USER

Line 864: FROM fnd_user_preferences

860: IS
861:
862: CURSOR c_get_users_w_primary_cc_set IS
863: SELECT user_name, preference_value
864: FROM fnd_user_preferences
865: WHERE module_name = 'IBE'
866: AND preference_name = 'PRIMARY_CARD';
867:
868: cursor c_check_assignment_id (c_instrument_id NUMBER, c_party_id NUMBER) is

Line 891: cursor c_find_fnd_user (c_user_name VARCHAR2) is

887: AND cust_account_id IS NULL
888: AND acct_site_use_id IS NULL;
889:
890:
891: cursor c_find_fnd_user (c_user_name VARCHAR2) is
892: SELECT customer_id, person_party_id
893: FROM fnd_user
894: WHERE user_name = c_user_name;
895:

Line 893: FROM fnd_user

889:
890:
891: cursor c_find_fnd_user (c_user_name VARCHAR2) is
892: SELECT customer_id, person_party_id
893: FROM fnd_user
894: WHERE user_name = c_user_name;
895:
896:
897: l_status VARCHAR2(1);

Line 914: rec_find_fnd_user c_find_fnd_user%rowtype;

910: rec_get_users_w_primary_cc_set c_get_users_w_primary_cc_set%rowtype;
911: rec_check_assignment_id c_check_assignment_id%rowtype;
912: rec_find_instr_payment_use c_find_instr_payment_use%rowtype;
913: rec_check_ext_payer_id c_check_ext_payer_id%rowtype;
914: rec_find_fnd_user c_find_fnd_user%rowtype;
915: --Define the global variable g_debug VARCHAR2(1) := 'N'
916:
917: BEGIN
918: /*IF p_debug_flag = 'Y' THEN

Line 946: --b) Get the party_id corresponding to the fnd_user using the following query

942: print_debug_log('Instrument id obtained from Upg_Instruments : '||l_instrument_id);
943: END IF;
944:
945:
946: --b) Get the party_id corresponding to the fnd_user using the following query
947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP
948:
949: l_customer_id := rec_find_fnd_user.customer_id;
950: l_person_party_id := rec_find_fnd_user.person_party_id;

Line 947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP

943: END IF;
944:
945:
946: --b) Get the party_id corresponding to the fnd_user using the following query
947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP
948:
949: l_customer_id := rec_find_fnd_user.customer_id;
950: l_person_party_id := rec_find_fnd_user.person_party_id;
951: EXIT WHEN c_find_fnd_user%NOTFOUND;

Line 949: l_customer_id := rec_find_fnd_user.customer_id;

945:
946: --b) Get the party_id corresponding to the fnd_user using the following query
947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP
948:
949: l_customer_id := rec_find_fnd_user.customer_id;
950: l_person_party_id := rec_find_fnd_user.person_party_id;
951: EXIT WHEN c_find_fnd_user%NOTFOUND;
952: END LOOP;
953:

Line 950: l_person_party_id := rec_find_fnd_user.person_party_id;

946: --b) Get the party_id corresponding to the fnd_user using the following query
947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP
948:
949: l_customer_id := rec_find_fnd_user.customer_id;
950: l_person_party_id := rec_find_fnd_user.person_party_id;
951: EXIT WHEN c_find_fnd_user%NOTFOUND;
952: END LOOP;
953:
954: IF p_debug_flag = 'T' THEN

Line 951: EXIT WHEN c_find_fnd_user%NOTFOUND;

947: FOR rec_find_fnd_user in c_find_fnd_user(rec_get_users_w_primary_cc_set.user_name) LOOP
948:
949: l_customer_id := rec_find_fnd_user.customer_id;
950: l_person_party_id := rec_find_fnd_user.person_party_id;
951: EXIT WHEN c_find_fnd_user%NOTFOUND;
952: END LOOP;
953:
954: IF p_debug_flag = 'T' THEN
955: print_debug_log('CUstomer Id and person party id from FND USER : '||l_customer_id ||','||l_person_party_id);

Line 955: print_debug_log('CUstomer Id and person party id from FND USER : '||l_customer_id ||','||l_person_party_id);

951: EXIT WHEN c_find_fnd_user%NOTFOUND;
952: END LOOP;
953:
954: IF p_debug_flag = 'T' THEN
955: print_debug_log('CUstomer Id and person party id from FND USER : '||l_customer_id ||','||l_person_party_id);
956: END IF;
957:
958:
959: -- If the customer_id does not have any value, use the person_party_id value instead.