DBA Data[Home] [Help]

APPS.PV_PARTNER_ACCNT_MGMT_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 83: SELECT generate_customer_number INTO l_gen_cust_num FROM ar_system_parameters;

79: organization_rec.Created_by_Module := 'PV';
80: cust_profile_rec.Created_by_Module := 'PV';
81:
82: -- if needed generate account_number.
83: SELECT generate_customer_number INTO l_gen_cust_num FROM ar_system_parameters;
84:
85: -- typically should be set to 'Y' if no we will try to create a new one.
86: -- however, this could error out
87: -- Is this needed????

Line 544: SELECT AUTO_SITE_NUMBERING INTO l_profile FROM AR_SYSTEM_PARAMETERS;

540: PVX_UTILITY_PVT.debug_message('create acct_site_use:l_location '||l_location);
541:
542: END IF;
543:
544: SELECT AUTO_SITE_NUMBERING INTO l_profile FROM AR_SYSTEM_PARAMETERS;
545:
546: IF l_profile = 'N' then
547: p_acct_site_uses_Rec.location := substr(p_acct_Site_type ||' ' ||
548: l_location ||' ' ||