DBA Data[Home] [Help]

APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on RCV_PARAMETERS

Line 2361: CURSOR c_rcv_parameters(cp_organization_id number) IS

2357: FROM JAI_RGM_DEFINITIONS
2358: WHERE regime_id = NVL(cp_regime_id, regime_id)
2359: AND regime_code = NVL(cp_regime_code, regime_code);
2360:
2361: CURSOR c_rcv_parameters(cp_organization_id number) IS
2362: SELECT receiving_account_id
2363: FROM rcv_parameters
2364: WHERE organization_id = cp_organization_id;
2365:

Line 2363: FROM rcv_parameters

2359: AND regime_code = NVL(cp_regime_code, regime_code);
2360:
2361: CURSOR c_rcv_parameters(cp_organization_id number) IS
2362: SELECT receiving_account_id
2363: FROM rcv_parameters
2364: WHERE organization_id = cp_organization_id;
2365:
2366: lv_ttype_receive JAI_RCV_TRANSACTIONS.transaction_type%type;
2367: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type;

Line 2403: r_rcv_parameters c_rcv_parameters%rowtype;

2399: )
2400: ORDER BY transaction_id;
2401:
2402: r_regime c_regime%ROWTYPE;
2403: r_rcv_parameters c_rcv_parameters%rowtype;
2404: r_receive_transaction c_receive_transaction%ROWTYPE;
2405:
2406:
2407: /* File.Sql.35 by Brathod */

Line 2472: r_rcv_parameters := NULL;

2468: cp_batch_id => p_batch_id)
2469: LOOP
2470:
2471: r_receive_transaction := NULL;
2472: r_rcv_parameters := NULL;
2473:
2474: lv_reference_10 := 'India Local UnClaim VAT Entries for Receipt:'||r_shipment_lines.receipt_num||'. Transaction Type VAT Unclaim';
2475:
2476: lv_reference_25 := r_shipment_lines.transaction_id;

Line 2484: OPEN c_rcv_parameters(r_receive_transaction.organization_id);

2480: OPEN c_receive_transaction(r_shipment_lines.shipment_header_id, r_shipment_lines.shipment_line_id);
2481: FETCH c_receive_transaction INTO r_receive_transaction;
2482: CLOSE c_receive_transaction;
2483:
2484: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2485: FETCH c_rcv_parameters into r_rcv_parameters;
2486: CLOSE c_rcv_parameters;
2487:
2488: --Pass the accounting entry

Line 2485: FETCH c_rcv_parameters into r_rcv_parameters;

2481: FETCH c_receive_transaction INTO r_receive_transaction;
2482: CLOSE c_receive_transaction;
2483:
2484: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2485: FETCH c_rcv_parameters into r_rcv_parameters;
2486: CLOSE c_rcv_parameters;
2487:
2488: --Pass the accounting entry
2489: lv_ttype_receive := 'RECEIVE' ;

Line 2486: CLOSE c_rcv_parameters;

2482: CLOSE c_receive_transaction;
2483:
2484: OPEN c_rcv_parameters(r_receive_transaction.organization_id);
2485: FETCH c_rcv_parameters into r_rcv_parameters;
2486: CLOSE c_rcv_parameters;
2487:
2488: --Pass the accounting entry
2489: lv_ttype_receive := 'RECEIVE' ;
2490: lv_ttype_correct := 'CORRECT' ;

Line 2502: ln_code_combination_id := r_rcv_parameters.receiving_account_id;

2498: LOOP
2499: lv_currency_code := jai_constants.func_curr;
2500:
2501: --DR Inventory Receiving
2502: ln_code_combination_id := r_rcv_parameters.receiving_account_id;
2503:
2504: ln_entered_dr := rec_tax.tax_amount*ln_apportion_factor;
2505: ln_entered_cr := NULL;
2506: