eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RETRO_PRC_PKG dependencies on MTL_PARAMETERS

Line 904: CURSOR get_mtl_parameters_cur IS

900: FROM rcv_transactions
901: WHERE transaction_id = pn_transaction_id;
902:
903:
904: CURSOR get_mtl_parameters_cur IS
905: SELECT
906: primary_cost_method
907: , expense_account
908: , purchase_price_var_account

Line 911: mtl_parameters

907: , expense_account
908: , purchase_price_var_account
909: , organization_code
910: FROM
911: mtl_parameters
912: WHERE
913: organization_id = pn_organization_id;
914:
915: CURSOR get_rcv_parameters_cur IS

Line 924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

920: rcv_parameters
921: WHERE
922: organization_id = pn_organization_id;
923:
924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%TYPE;

Line 928: ln_expense_account mtl_parameters.expense_account%TYPE;

924: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
925: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
926: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
927: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
928: ln_expense_account mtl_parameters.expense_account%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;

Line 932: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;

928: ln_expense_account mtl_parameters.expense_account%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;

Line 941: lv_organization_code mtl_parameters.organization_code%TYPE;/added by rchandan/

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;
941: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/
942: BEGIN
943: --logging for debug
944: IF (ln_proc_level >= ln_dbg_level)
945: THEN

Line 952: OPEN get_mtl_parameters_cur;

948: , 'Enter procedure'
949: );
950: END IF; --l_proc_level>=l_dbg_level
951:
952: OPEN get_mtl_parameters_cur;
953: FETCH get_mtl_parameters_cur
954: INTO
955: lv_primary_cost_method
956: , ln_expense_account

Line 953: FETCH get_mtl_parameters_cur

949: );
950: END IF; --l_proc_level>=l_dbg_level
951:
952: OPEN get_mtl_parameters_cur;
953: FETCH get_mtl_parameters_cur
954: INTO
955: lv_primary_cost_method
956: , ln_expense_account
957: , ln_purchase_price_var_account

Line 959: CLOSE get_mtl_parameters_cur;

955: lv_primary_cost_method
956: , ln_expense_account
957: , ln_purchase_price_var_account
958: , lv_organization_code;
959: CLOSE get_mtl_parameters_cur;
960:
961: IF (ln_proc_level >= ln_dbg_level)
962: THEN
963: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');

Line 1433: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;

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:
1437: lv_codepath VARCHAR2(4000);

Line 1557: --Get the ap_accrual_account from mtl_parameters for the current organization id

1553: THEN
1554: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');
1555: END IF; --l_proc_level>=l_dbg_level
1556:
1557: --Get the ap_accrual_account from mtl_parameters for the current organization id
1558: SELECT
1559: Ap_Accrual_Account
1560: INTO
1561: ln_ap_accrual_acc

Line 1563: Mtl_Parameters

1559: Ap_Accrual_Account
1560: INTO
1561: ln_ap_accrual_acc
1562: FROM
1563: Mtl_Parameters
1564: WHERE organization_id = ln_organization_id;
1565:
1566: IF (ln_proc_level >= ln_dbg_level)
1567: THEN

Line 1886: --Get the primary_cost_method from mtl_parameters for the organization

1882: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1883: , 'Enter procedure'
1884: );
1885: END IF; --l_proc_level>=l_dbg_level
1886: --Get the primary_cost_method from mtl_parameters for the organization
1887:
1888: OPEN get_rcv_transactions_cur;
1889: FETCH get_rcv_transactions_cur
1890: INTO

Line 2292: --Get the primary_cost_method from mtl_parameters for the organization

2288: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2289: , 'Enter procedure'
2290: );
2291: END IF; --l_proc_level>=l_dbg_level
2292: --Get the primary_cost_method from mtl_parameters for the organization
2293:
2294: --Call the following procedure to decide if Claim is valid for this transaction
2295: JAI_RCV_EXCISE_PROCESSING_PKG.Validate_Transaction
2296: ( p_transaction_id => pn_transaction_id