DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 1172: FROM wsm_split_merge_transactions wsmt,

1168: l_later_txn_exists := 0;
1169:
1170: SELECT 1
1171: INTO l_later_txn_exists
1172: FROM wsm_split_merge_transactions wsmt,
1173: wsm_sm_starting_jobs wst
1174: WHERE wsmt.transaction_id = wst.transaction_id
1175: AND wst.wip_entity_id = p_sj_wip_entity_id
1176: AND wsmt.transaction_date > p_txn_date

Line 7415: INSERT INTO wsm_split_merge_transactions(

7411:
7412: l_stmt_num := 20;
7413:
7414: -- Start insert into WSMT table
7415: INSERT INTO wsm_split_merge_transactions(
7416: TRANSACTION_ID,
7417: TRANSACTION_TYPE_ID,
7418: ORGANIZATION_ID,
7419: INTERNAL_GROUP_ID,

Line 7500: p_msg_text => 'Inserted Txn Header Data into the wsm_split_merge_transactions',

7496:
7497: if( g_log_level_statement >= l_log_level ) then
7498: l_msg_tokens.delete;
7499: WSM_log_PVT.logMessage(p_module_name => l_module ,
7500: p_msg_text => 'Inserted Txn Header Data into the wsm_split_merge_transactions',
7501: p_stmt_num => l_stmt_num ,
7502: p_msg_tokens => l_msg_tokens,
7503: p_fnd_log_level => g_log_level_statement,
7504: p_run_log_level => l_log_level