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 909: CURSOR get_mtl_parameters_cur IS

905: FROM rcv_transactions
906: WHERE transaction_id = pn_transaction_id;
907:
908:
909: CURSOR get_mtl_parameters_cur IS
910: SELECT
911: primary_cost_method
912: , expense_account
913: , purchase_price_var_account

Line 916: mtl_parameters

912: , expense_account
913: , purchase_price_var_account
914: , organization_code
915: FROM
916: mtl_parameters
917: WHERE
918: organization_id = pn_organization_id;
919:
920: CURSOR get_rcv_parameters_cur IS

Line 929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;

925: rcv_parameters
926: WHERE
927: organization_id = pn_organization_id;
928:
929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
933: ln_expense_account mtl_parameters.expense_account%TYPE;

Line 933: ln_expense_account mtl_parameters.expense_account%TYPE;

929: lv_primary_cost_method mtl_parameters.primary_cost_method%TYPE;
930: lv_destination_type_code jai_rcv_transactions.destination_type_code%TYPE;
931: ln_shipment_line_id jai_rcv_transactions.shipment_line_id%TYPE;
932: lv_receipt_num jai_rcv_transactions.receipt_num%TYPE;
933: ln_expense_account mtl_parameters.expense_account%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;

Line 937: ln_purchase_price_var_account mtl_parameters.purchase_price_var_account%TYPE;

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

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

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;
946: lv_organization_code mtl_parameters.organization_code%TYPE;/*added by rchandan*/
947: BEGIN
948: --logging for debug
949: IF (ln_proc_level >= ln_dbg_level)
950: THEN

Line 957: OPEN get_mtl_parameters_cur;

953: , 'Enter procedure'
954: );
955: END IF; --l_proc_level>=l_dbg_level
956:
957: OPEN get_mtl_parameters_cur;
958: FETCH get_mtl_parameters_cur
959: INTO
960: lv_primary_cost_method
961: , ln_expense_account

Line 958: FETCH get_mtl_parameters_cur

954: );
955: END IF; --l_proc_level>=l_dbg_level
956:
957: OPEN get_mtl_parameters_cur;
958: FETCH get_mtl_parameters_cur
959: INTO
960: lv_primary_cost_method
961: , ln_expense_account
962: , ln_purchase_price_var_account

Line 964: CLOSE get_mtl_parameters_cur;

960: lv_primary_cost_method
961: , ln_expense_account
962: , ln_purchase_price_var_account
963: , lv_organization_code;
964: CLOSE get_mtl_parameters_cur;
965:
966: IF (ln_proc_level >= ln_dbg_level)
967: THEN
968: FND_FILE.PUT_LINE(fnd_file.log,'Do_Unclaim 1');

Line 1438: ln_ap_accrual_acc Mtl_Parameters.Ap_Accrual_Account%TYPE;

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

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

1558: THEN
1559: FND_FILE.PUT_LINE(fnd_file.log,'Do_Accounting 4');
1560: END IF; --l_proc_level>=l_dbg_level
1561:
1562: --Get the ap_accrual_account from mtl_parameters for the current organization id
1563: SELECT
1564: Ap_Accrual_Account
1565: INTO
1566: ln_ap_accrual_acc

Line 1568: Mtl_Parameters

1564: Ap_Accrual_Account
1565: INTO
1566: ln_ap_accrual_acc
1567: FROM
1568: Mtl_Parameters
1569: WHERE organization_id = ln_organization_id;
1570:
1571: IF (ln_proc_level >= ln_dbg_level)
1572: THEN

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

1887: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
1888: , 'Enter procedure'
1889: );
1890: END IF; --l_proc_level>=l_dbg_level
1891: --Get the primary_cost_method from mtl_parameters for the organization
1892:
1893: OPEN get_rcv_transactions_cur;
1894: FETCH get_rcv_transactions_cur
1895: INTO

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

2297: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.begin'
2298: , 'Enter procedure'
2299: );
2300: END IF; --l_proc_level>=l_dbg_level
2301: --Get the primary_cost_method from mtl_parameters for the organization
2302:
2303: --Call the following procedure to decide if Claim is valid for this transaction
2304: JAI_RCV_EXCISE_PROCESSING_PKG.Validate_Transaction
2305: ( p_transaction_id => pn_transaction_id