APPS.OE_CREDIT_PUB dependencies on FND_PROFILE

Line 1238: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;

1234: oe_debug_pub.ADD('Shipping Horizon days ='||to_char(l_shipping_horizon, 'DD-MON-YYYY'));
1235: oe_debug_pub.ADD('Include Risk flag ='||l_include_risk_flag);
1236:
1237: /* additional task */
1238: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
1239: oe_debug_pub.ADD('Estimated Valid Days ='||to_char(l_est_valid_days));
1240:
1241: -- Move the following SQL out of if clause for customer credit level
1242: -- because even for site credit level, we need to pass pay_from_customer

Line 2923: to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0'));

2919: oe_debug_pub.ADD('Shipping Horizon days ='||to_char(l_shipping_horizon, 'DD-MON-YYYY'));
2920: oe_debug_pub.ADD('Include Risk flag ='||l_include_risk_flag);
2921:
2922: l_est_valid_days :=
2923: to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0'));
2924: oe_debug_pub.ADD('Estimated Valid Days ='||to_char(l_est_valid_days));
2925:
2926:
2927: IF p_credit_level = 'CUSTOMER' THEN