APPS.JAI_RETRO_PRC_PKG dependencies on RCV_PARAMETERS

Line 915: CURSOR get_rcv_parameters_cur IS

911: mtl_parameters
912: WHERE
913: organization_id = pn_organization_id;
914:
915: CURSOR get_rcv_parameters_cur IS
916: SELECT
917: retroprice_adj_account_id
918: , receiving_account_id
919: FROM

Line 920: rcv_parameters

916: SELECT
917: retroprice_adj_account_id
918: , receiving_account_id
919: FROM
920: rcv_parameters
921: WHERE
922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

Line 933: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;

929: lv_process_message VARCHAR2(500);
930: lv_process_status VARCHAR2(500);
931: lv_code_path VARCHAR2(500);
932: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;
933: ln_retroprice_adj_account_id rcv_parameters.retroprice_adj_account_id%TYPE;
934: func_curr_det_rec jai_plsql_cache_pkg.func_curr_details;
935: lv_period_name gl_periods.period_name%TYPE;
936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;
937: ln_user_id NUMBER := fnd_global.user_id;

Line 936: ln_receiving_account_id rcv_parameters.receiving_account_id%TYPE;

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

Line 970: OPEN get_rcv_parameters_cur;

966: FND_FILE.PUT_LINE(fnd_file.log,'ln_purchase_price_var_account '|| ln_purchase_price_var_account);
967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level
969:
970: OPEN get_rcv_parameters_cur;
971: FETCH get_rcv_parameters_cur
972: INTO
973: ln_retroprice_adj_account_id,
974: ln_receiving_account_id;

Line 971: FETCH get_rcv_parameters_cur

967: FND_FILE.PUT_LINE(fnd_file.log,'lv_organization_code '|| lv_organization_code);
968: END IF; --l_proc_level>=l_dbg_level
969:
970: OPEN get_rcv_parameters_cur;
971: FETCH get_rcv_parameters_cur
972: INTO
973: ln_retroprice_adj_account_id,
974: ln_receiving_account_id;
975: CLOSE get_rcv_parameters_cur;

Line 975: CLOSE get_rcv_parameters_cur;

971: FETCH get_rcv_parameters_cur
972: INTO
973: ln_retroprice_adj_account_id,
974: ln_receiving_account_id;
975: CLOSE get_rcv_parameters_cur;
976:
977: IF (ln_proc_level >= ln_dbg_level)
978: THEN
979: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 2');

Line 1432: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;

1428: ln_tax_diff_tot NUMBER;
1429: lv_currency Jai_Retro_Tax_Changes.Currency_Code%TYPE;
1430: ln_curr_conv_rate Rcv_Transactions.Currency_Conversion_Rate%TYPE;
1431: ln_organization_id Rcv_Transactions.Organization_Id%TYPE;
1432: ln_recv_acct_id Rcv_Parameters.Receiving_Account_Id%TYPE;
1433: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;
1434: ln_non_rec_amount NUMBER;
1435: lv_include_cenvat_in_costing VARCHAR2(10);
1436:

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

1501:
1502: --IF the total difference is NOT EQUAL to ZERO THEN
1503: IF ln_tax_diff_tot <> 0
1504: THEN
1505: --Get the receiving_account_id from rcv_parameters for the current organization id
1506: SELECT
1507: receiving_account_id
1508: INTO
1509: ln_recv_acct_id

Line 1511: Rcv_Parameters

1507: receiving_account_id
1508: INTO
1509: ln_recv_acct_id
1510: FROM
1511: Rcv_Parameters
1512: WHERE organization_id = ln_organization_id;
1513:
1514: IF (ln_proc_level >= ln_dbg_level)
1515: THEN