DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_TRANSACTION_TYPES

Line 1035: ln_transaction_type_id MTL_TRANSACTION_TYPES.transaction_type_id%TYPE;

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

Line 1036: ln_transaction_source_type_id MTL_TRANSACTION_TYPES.transaction_source_type_id%TYPE;

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

Line 1037: ln_transaction_action_id MTL_TRANSACTION_TYPES.transaction_action_id%TYPE;

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

Line 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