APPS.OE_INLINE_CUSTOMER_PUB dependencies on AR_SYSTEM_PARAMETERS

Line 20: l_sysparm_rec ar_system_parameters%rowtype;

16:
17: -- { Start of procedure Initialize_Global
18: PROCEDURE Initialize_Global( x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2)
19: IS
20: l_sysparm_rec ar_system_parameters%rowtype;
21: l_sys_parm_rec ar_system_parameters_all%rowtype;
22: --
23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --

Line 21: l_sys_parm_rec ar_system_parameters_all%rowtype;

17: -- { Start of procedure Initialize_Global
18: PROCEDURE Initialize_Global( x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2)
19: IS
20: l_sysparm_rec ar_system_parameters%rowtype;
21: l_sys_parm_rec ar_system_parameters_all%rowtype;
22: --
23: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
24: --
25: Begin

Line 32: -- { Start of the ar_system_parameters select and assignment

28: oe_debug_pub.add( 'ENTERING PROCEDURE INITIALIZE_GLOBAL' ) ;
29: END IF;
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: -- { Start of the ar_system_parameters select and assignment
33:
34: IF oe_code_control.code_release_level < '110510' THEN
35: Select *
36: Into l_sysparm_rec

Line 37: From ar_system_parameters;

33:
34: IF oe_code_control.code_release_level < '110510' THEN
35: Select *
36: Into l_sysparm_rec
37: From ar_system_parameters;
38: ELSE
39: l_Sys_Parm_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
40: END IF;
41:

Line 55: -- End of the ar_system_parameters select and assignment}

51: G_AUTO_CUST_NUMBERING := nvl(l_sys_parm_rec.generate_customer_number,'Y');
52: G_AUTO_LOCATION_NUMBERING := nvl(l_sys_parm_rec.auto_site_numbering,'Y');
53: END IF;
54:
55: -- End of the ar_system_parameters select and assignment}
56:
57: -- { Start for global values from profile
58: fnd_profile.get('ONT_MANDATE_CUSTOMER_EMAIL',G_EMAIL_REQUIRED);
59: fnd_profile.get('HZ_GENERATE_PARTY_NUMBER',G_AUTO_PARTY_NUMBERING);

Line 1026: -- ar_system_parameters.generate_customer_number is the column

1022: l_account_rec.global_attribute20 := customer_rec.global_attribute20;
1023:
1024: -- This information will have the customer_number is the auto
1025: -- generation of the account number is set to 'N'.
1026: -- ar_system_parameters.generate_customer_number is the column
1027: -- to check for the value
1028: -- If the value is 'N' and interface table do not have value
1029: -- for the New_Account_Number then the call to hz api will return
1030: -- error that the value need to be passed and that will be displayed