DBA Data[Home] [Help]

APPS.ASO_CHECK_TCA_PVT dependencies on FND_PROFILE

Line 1670: l_create_acct_prof VARCHAR2(30) := NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED');

1666: l_party_type VARCHAR2(30);
1667: l_api_version CONSTANT NUMBER := 1.0;
1668: l_api_name CONSTANT VARCHAR2(45) := 'Customer_Account';
1669: l_object_party_id NUMBER;
1670: l_create_acct_prof VARCHAR2(30) := NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED');
1671:
1672: BEGIN
1673:
1674: ---- Initialize---------------------

Line 3342: l_create_acct_prof VARCHAR2(30) := NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED');

3338: WHERE party_id = pty_id
3339: AND status = 'A'
3340: AND sysdate BETWEEN NVL(account_activation_date, sysdate) AND NVL(account_termination_date, sysdate);
3341:
3342: l_create_acct_prof VARCHAR2(30) := NVL(FND_PROFILE.Value('ASO_AUTO_ACCOUNT_CREATE'), 'AS_REQUIRED');
3343: l_dummy VARCHAR2(1) := NULL;
3344: l_party NUMBER := NULL;
3345: l_cust_acct NUMBER := NULL;
3346: l_api_version CONSTANT NUMBER := 1.0;