1031: ln_value_change NUMBER;
1032: lv_result BOOLEAN;
1033:
1034: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
1035: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
1036: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
1037: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
1038:
1039: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
1032: lv_result BOOLEAN;
1033:
1034: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
1035: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
1036: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
1037: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
1038:
1039: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
1040: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
1033:
1034: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
1035: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
1036: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
1037: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
1038:
1039: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
1040: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
1041: FROM mtl_transaction_types
1037: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
1038:
1039: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
1040: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
1041: FROM mtl_transaction_types
1042: WHERE transaction_type_name = cp_transaction_type_name;
1043:
1044: CURSOR c_account_period_id(cp_organization_id IN NUMBER, cp_transaction_date IN DATE) IS
1045: SELECT acct_period_id