975: ln_value_change NUMBER;
976: lv_result BOOLEAN;
977:
978: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
979: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
980: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
981: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
982:
983: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
976: lv_result BOOLEAN;
977:
978: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
979: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
980: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
981: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
982:
983: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
984: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
977:
978: lv_transaction_type_name VARCHAR2(30); --File.Sql.35 Cbabu := 'Average cost update';
979: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;
980: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;
981: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
982:
983: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
984: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
985: FROM mtl_transaction_types
981: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;
982:
983: CURSOR c_trx_type_dtls(cp_transaction_type_name IN VARCHAR2) IS
984: SELECT transaction_type_id, transaction_source_type_id, transaction_action_id
985: FROM mtl_transaction_types
986: WHERE transaction_type_name = cp_transaction_type_name;
987:
988: CURSOR c_account_period_id(cp_organization_id IN NUMBER, cp_transaction_date IN DATE) IS
989: SELECT acct_period_id