DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_PARAMETERS

Line 2441: CURSOR c_rcv_parameters(cp_organization_id number) IS

2437: FROM JAI_RGM_DEFINITIONS
2438: WHERE regime_id = NVL(cp_regime_id, regime_id)
2439: AND regime_code = NVL(cp_regime_code, regime_code);
2440:
2441: CURSOR c_rcv_parameters(cp_organization_id number) IS
2442: SELECT receiving_account_id
2443: FROM rcv_parameters
2444: WHERE organization_id = cp_organization_id;
2445:

Line 2443: FROM rcv_parameters

2439: AND regime_code = NVL(cp_regime_code, regime_code);
2440:
2441: CURSOR c_rcv_parameters(cp_organization_id number) IS
2442: SELECT receiving_account_id
2443: FROM rcv_parameters
2444: WHERE organization_id = cp_organization_id;
2445:
2446: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2447: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;

Line 2503: r_rcv_parameters c_rcv_parameters%rowtype;

2499: -- Added by Jia for FP Bug#8805693, End
2500:
2501:
2502: r_regime c_regime%ROWTYPE;
2503: r_rcv_parameters c_rcv_parameters%rowtype;
2504: r_receive_transaction c_receive_transaction%ROWTYPE;
2505:
2506:
2507: /* File.Sql.35 by Brathod */

Line 2612: r_rcv_parameters := NULL;

2608: cp_batch_id => p_batch_id)
2609: LOOP
2610:
2611: r_receive_transaction := NULL;
2612: r_rcv_parameters := NULL;
2613:
2614: lv_reference_10 := 'India Local UnClaim VAT Entries for Receipt:'||r_shipment_lines.receipt_num||'. Transaction Type VAT Unclaim';
2615:
2616: lv_reference_25 := r_shipment_lines.transaction_id;

Line 2624: OPEN c_rcv_parameters(r_receive_transaction.organization_id);

2620: OPEN c_receive_transaction(r_shipment_lines.shipment_header_id, r_shipment_lines.shipment_line_id);
2621: FETCH c_receive_transaction INTO r_receive_transaction;
2622: CLOSE c_receive_transaction;
2623:
2624: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2625: FETCH c_rcv_parameters into r_rcv_parameters;
2626: CLOSE c_rcv_parameters;
2627:
2628: --Pass the accounting entry

Line 2625: FETCH c_rcv_parameters into r_rcv_parameters;

2621: FETCH c_receive_transaction INTO r_receive_transaction;
2622: CLOSE c_receive_transaction;
2623:
2624: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2625: FETCH c_rcv_parameters into r_rcv_parameters;
2626: CLOSE c_rcv_parameters;
2627:
2628: --Pass the accounting entry
2629: lv_ttype_receive := 'RECEIVE' ;

Line 2626: CLOSE c_rcv_parameters;

2622: CLOSE c_receive_transaction;
2623:
2624: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2625: FETCH c_rcv_parameters into r_rcv_parameters;
2626: CLOSE c_rcv_parameters;
2627:
2628: --Pass the accounting entry
2629: lv_ttype_receive := 'RECEIVE' ;
2630: lv_ttype_correct := 'CORRECT' ;

Line 2654: ln_code_combination_id := r_rcv_parameters.receiving_account_id;

2650: LOOP
2651: lv_currency_code := jai_constants.func_curr;
2652:
2653: --DR Inventory Receiving
2654: ln_code_combination_id := r_rcv_parameters.receiving_account_id;
2655:
2656: ln_entered_dr := rec_tax.tax_amount*ln_apportion_factor * ln_available_qty_apportion;--Updated by Wenqiong for bug 14743050, add ln_available_qty_apportion.
2657: ln_entered_cr := NULL;
2658: