DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_TRANSACTION_TYPES

Line 979: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;

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

Line 980: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;

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

Line 981: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;

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

Line 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