APPS.JTF_UM_USERTYPE_CREDENTIALS dependencies on DUAL

Line 62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

58: l_gen_cust_no := 'Y';
59: end;
60:
61: IF l_gen_cust_no <> 'Y' THEN
62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
63: END IF;
64:
65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
66:

Line 65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

61: IF l_gen_cust_no <> 'Y' THEN
62: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
63: END IF;
64:
65: -- SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
66:
67:
68: if l_party_type = 'PERSON' then
69:

Line 70: -- create new account for Individual User

66:
67:
68: if l_party_type = 'PERSON' then
69:
70: -- create new account for Individual User
71:
72: jtf_customer_accounts_pvt.create_account(
73: p_api_version => 1,
74: p_init_msg_list => 'T',

Line 254: IF (nvl(FND_PROFILE.value('JTF_INDIVIDUALUSER_ACCOUNT'),'N') <> 'Y')

250:
251: P_PARTY_ID := l_customer_id;
252:
253: /* Bug 3493035
254: IF (nvl(FND_PROFILE.value('JTF_INDIVIDUALUSER_ACCOUNT'),'N') <> 'Y')
255: THEN
256: l_profile := FALSE;
257: END IF;*/
258:

Line 788: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

784: p_message =>'l_party_type:' || l_party_type
785: );
786: end if;
787:
788: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
789: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
790: then
791:
792: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then

Line 792: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then

788: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
789: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
790: then
791:
792: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then
793: if l_party_type = 'PERSON' then
794:
795: -- create new account for Individual User
796:

Line 795: -- create new account for Individual User

791:
792: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then
793: if l_party_type = 'PERSON' then
794:
795: -- create new account for Individual User
796:
797: jtf_customer_accounts_pvt.create_account(
798: p_api_version => 1,
799: p_init_msg_list => 'T',

Line 942: l_usertype_key := 'INDIVIDUALUSER';

938: IF UPPER(P_ACCOUNT_TYPE) = 'BUSINESSUSER' THEN
939: l_usertype_key := 'BUSINESSUSER';
940:
941: ELSE
942: l_usertype_key := 'INDIVIDUALUSER';
943:
944: END IF;
945:
946: -- Find out user type id

Line 1002: l_usertype_key := 'INDIVIDUALUSER';

998: IF UPPER(P_ACCOUNT_TYPE) = 'BUSINESSUSER' THEN
999: l_usertype_key := 'BUSINESSUSER';
1000:
1001: ELSE
1002: l_usertype_key := 'INDIVIDUALUSER';
1003:
1004: END IF;
1005:
1006: -- Find out user type id