APPS.JAI_RETRO_PRC_PKG dependencies on RCV_PARAMETERS

Line 920: CURSOR get_rcv_parameters_cur IS

916: mtl_parameters
917: WHERE
918: organization_id = pn_organization_id;
919:
920: CURSOR get_rcv_parameters_cur IS
921: SELECT
922: retroprice_adj_account_id
923: , receiving_account_id
924: FROM

Line 925: rcv_parameters

921: SELECT
922: retroprice_adj_account_id
923: , receiving_account_id
924: FROM
925: rcv_parameters
926: WHERE
927: organization_id = pn_organization_id;
928:
929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

Line 938: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;

934: lv_process_message VARCHAR2(500);
935: lv_process_status VARCHAR2(500);
936: lv_code_path VARCHAR2(500);
937: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;
938: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
939: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
940: lv_period_name gl_periods.period_name%TYPE;
941: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
942: ln_user_id NUMBER := fnd_global.user_id;

Line 941: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;

937: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;
938: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
939: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
940: lv_period_name gl_periods.period_name%TYPE;
941: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
942: ln_user_id NUMBER := fnd_global.user_id;
943: lv_procedure_name VARCHAR2(40):='Do_Unclaim';
944: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
945: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

Line 975: OPEN get_rcv_parameters_cur;

971: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
972: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
973: END IF; --l_proc_level>=l_dbg_level
974:
975: OPEN get_rcv_parameters_cur;
976: FETCH get_rcv_parameters_cur
977: INTO
978: ln_retroprice_adj_account_id,
979: ln_receiving_account_id;

Line 976: FETCH get_rcv_parameters_cur

972: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
973: END IF; --l_proc_level>=l_dbg_level
974:
975: OPEN get_rcv_parameters_cur;
976: FETCH get_rcv_parameters_cur
977: INTO
978: ln_retroprice_adj_account_id,
979: ln_receiving_account_id;
980: CLOSE get_rcv_parameters_cur;

Line 980: CLOSE get_rcv_parameters_cur;

976: FETCH get_rcv_parameters_cur
977: INTO
978: ln_retroprice_adj_account_id,
979: ln_receiving_account_id;
980: CLOSE get_rcv_parameters_cur;
981:
982: IF (ln_proc_level >= ln_dbg_level)
983: THEN
984: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');

Line 1437: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;

1433: ln_tax_diff_tot NUMBER;
1434: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1435: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1436: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1437: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1438: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1439: ln_non_rec_amount NUMBER;
1440: lv_include_cenvat_in_costing VARCHAR2(10);
1441:

Line 1510: --Get the receiving_account_id from rcv_parameters for the current organization id

1506:
1507: --IF the total difference is NOT EQUAL to ZERO THEN
1508: IF ln_tax_diff_tot <> 0
1509: THEN
1510: --Get the receiving_account_id from rcv_parameters for the current organization id
1511: SELECT
1512: receiving_account_id
1513: INTO
1514: ln_recv_acct_id

Line 1516: Rcv_Parameters

1512: receiving_account_id
1513: INTO
1514: ln_recv_acct_id
1515: FROM
1516: Rcv_Parameters
1517: WHERE organization_id = ln_organization_id;
1518:
1519: IF (ln_proc_level >= ln_dbg_level)
1520: THEN