APPS.OE_PREPAYMENT_PVT dependencies on FND_PROFILE

Line 639: l_fnd_profile_value VARCHAR2(1);

635: l_msg_count NUMBER := 0 ;
636: l_msg_data VARCHAR2(2000):= NULL ;
637: l_result_out VARCHAR2(30) := NULL ;
638: l_return_status VARCHAR2(30) := NULL ;
639: l_fnd_profile_value VARCHAR2(1);
640: l_format_mask VARCHAR2(500);
641: l_trx_date DATE;
642: l_trxn_extension_id NUMBER; --R12 CC Encryption
643:

Line 721: l_fnd_profile_value := fnd_profile.value('ONT_PROCESS_PAYMENT_IMMEDIATELY');

717: IF l_debug_level > 0 THEN
718: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR L_PPP_HOLD_EXISTS IS: '||L_PPP_HOLD_EXISTS , 1 ) ;
719: END IF;
720:
721: l_fnd_profile_value := fnd_profile.value('ONT_PROCESS_PAYMENT_IMMEDIATELY');
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
725: END IF;

Line 724: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;

720:
721: l_fnd_profile_value := fnd_profile.value('ONT_PROCESS_PAYMENT_IMMEDIATELY');
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
725: END IF;
726:
727: IF l_ppp_hold_exists = 'N' THEN
728: IF l_fnd_profile_value= 'Y' THEN

Line 728: IF l_fnd_profile_value= 'Y' THEN

724: oe_debug_pub.add( 'OEXVPPYB: VALUE FOR PREPAYMENT PROFILE OPTION IS : '||L_FND_PROFILE_VALUE , 1 ) ;
725: END IF;
726:
727: IF l_ppp_hold_exists = 'N' THEN
728: IF l_fnd_profile_value= 'Y' THEN
729: l_process_payment := 'Y';
730: ELSE
731: l_apply_ppp_hold := 'Y';
732: END IF;

Line 792: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);

788: -- bug 3486808
789: --R12 CC Encryption
790: --Verify
791: /*l_trx_date := nvl(p_header_rec.ordered_date, sysdate)
792: - nvl( to_number(fnd_profile.value('ONT_DAYS_TO_BACKDATE_BANK_ACCT')), 0);
793:
794: arp_bank_pkg.process_cust_bank_account
795: ( p_trx_date => l_trx_date
796: , p_currency_code => p_header_rec.transactional_curr_code

Line 3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;

3315:
3316: select to_number(oe_sys_parameters.value ('SET_OF_BOOKS_ID')) into l_sob_id from dual;
3317:
3318: -- MOAC changes
3319: -- select fnd_profile.value('ORG_ID') into l_organization_id from DUAL;
3320: SELECT org_id
3321: INTO l_organization_id
3322: FROM oe_order_headers_all
3323: WHERE header_id = p_header_id;