APPS.OE_CREDIT_PUB dependencies on FND_PROFILE

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

1252: oe_debug_pub.ADD('Shipping Horizon days ='||to_char(l_shipping_horizon, 'DD-MON-YYYY'));
1253: oe_debug_pub.ADD('Include Risk flag ='||l_include_risk_flag);
1254:
1255: /* additional task */
1256: l_est_valid_days := to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0') ) ;
1257: oe_debug_pub.ADD('Estimated Valid Days ='||to_char(l_est_valid_days));
1258:
1259: -- Move the following SQL out of if clause for customer credit level
1260: -- because even for site credit level, we need to pass pay_from_customer

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

2955: oe_debug_pub.ADD('Shipping Horizon days ='||to_char(l_shipping_horizon, 'DD-MON-YYYY'));
2956: oe_debug_pub.ADD('Include Risk flag ='||l_include_risk_flag);
2957:
2958: l_est_valid_days :=
2959: to_number( nvl(fnd_profile.value('ONT_EST_AUTH_VALID_DAYS'), '0'));
2960: oe_debug_pub.ADD('Estimated Valid Days ='||to_char(l_est_valid_days));
2961:
2962:
2963: IF p_credit_level = 'CUSTOMER' THEN