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 843: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;

839: p_message =>'l_party_type:' || l_party_type
840: );
841: end if;
842:
843: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
844: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
845: then
846:
847: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then

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

843: SELECT hz_account_num_s.nextval into p_account_number FROM DUAL;
844: if(p_approval_id is null or p_approval_id = -1 OR l_party_type='PARTY_RELATIONSHIP')
845: then
846:
847: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then
848: if l_party_type = 'PERSON' then
849:
850: -- create new account for Individual User
851:

Line 850: -- create new account for Individual User

846:
847: --if P_USERTYPE_KEY = 'INDIVIDUALUSER' then
848: if l_party_type = 'PERSON' then
849:
850: -- create new account for Individual User
851:
852: jtf_customer_accounts_pvt.create_account(
853: p_api_version => 1,
854: p_init_msg_list => 'T',

Line 997: l_usertype_key := 'INDIVIDUALUSER';

993: IF UPPER(P_ACCOUNT_TYPE) = 'BUSINESSUSER' THEN
994: l_usertype_key := 'BUSINESSUSER';
995:
996: ELSE
997: l_usertype_key := 'INDIVIDUALUSER';
998:
999: END IF;
1000:
1001: -- Find out user type id

Line 1057: l_usertype_key := 'INDIVIDUALUSER';

1053: IF UPPER(P_ACCOUNT_TYPE) = 'BUSINESSUSER' THEN
1054: l_usertype_key := 'BUSINESSUSER';
1055:
1056: ELSE
1057: l_usertype_key := 'INDIVIDUALUSER';
1058:
1059: END IF;
1060:
1061: -- Find out user type id