The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT table_route_id
FROM pqh_table_route
WHERE table_alias = 'BPL';
SELECT process_log_id
FROM pqh_process_log
WHERE txn_id = p_folder_id
AND module_cd = 'BUDGET_REALLOCATION';
IS SELECT process_log_id,
txn_id,
information_category
FROM pqh_process_log
START WITH txn_id = p_transaction_id
AND master_process_log_id = p_batch_id
AND module_cd = 'BUDGET_REALLOCATION'
CONNECT BY PRIOR process_log_id = master_process_log_id;
SELECT fld.name,
pb.budget_name||'-'||bvr.version_number,
pb.budgeted_entity_cd,
fld.budget_unit_id
FROM pqh_budget_pools fld,
pqh_budgets pb,
pqh_budget_versions bvr
WHERE fld.pool_id = p_folder_id
AND fld.budget_version_id = bvr.budget_version_id
AND bvr.budget_id = pb.budget_id;
SELECT name
FROM pqh_budget_pools
WHERE pool_id = p_transaction_id;
hr_utility.set_location('Inserted a row for Transaction Level '||l_proc,20);
hr_utility.set_location('Inserted a row for Transaction-Donor Level '||l_proc,25);
hr_utility.set_location('Inserted a row for Transaction-Receiver Level '||l_proc,25);
hr_utility.set_location('Inserted a row for Transaction-Receive Level. Leaving '||l_proc,25);
SELECT COUNT(*)
FROM pqh_process_log
WHERE message_type_cd = p_message_type_cd
START WITH process_log_id = p_start_log_id
CONNECT BY PRIOR process_log_id = master_process_log_id;
update the 'start' record for this transaction with message_type_cd = 'COMPLETE'
*/
UPDATE pqh_process_log
SET message_type_cd = DECODE(message_type_cd,'ERROR',message_type_cd,'COMPLETE'),
message_text = DECODE(message_type_cd,'ERROR',message_text,fnd_message.get_string('PQH','PQH_PROCESS_COMPLETED')),
batch_status = DECODE(batch_status,'ERROR',batch_status,l_status),
batch_end_date = sysdate
WHERE process_log_id = l_process_log_id;
PROCEDURE update_log_message(p_folder_id IN Number
,p_txn_entity_type IN varchar2 ---- T/D/R/DP
,p_transaction_id IN Number Default Null
,p_entity_id IN Number Default Null
,p_budget_period_id IN NUMBER default Null
,p_message_type_cd IN varchar2 -- E/I/W
,p_message_text IN varchar2) IS
l_proc varchar2(80) := g_package||'update_log_message';
SELECT to_char(tp1.start_date,'DD-MM-RRRR')||' '||to_char(tp2.end_date,'DD-MM-RRRR')
FROM pqh_budget_periods bpr,
per_time_periods tp1,
per_time_periods tp2
WHERE bpr.budget_period_id = p_budget_period_id
AND tp1.time_period_id = bpr.start_time_period_id
AND tp2.time_period_id = bpr.end_time_period_id;
SELECT to_char(bpr.start_date,'DD-MM-RRRR')||' '||to_char(bpr.end_date,'DD-MM-RRRR')
FROM pqh_bdgt_pool_realloctions bpr
WHERE bpr.reallocation_id = p_budget_period_id;
UPDATE pqh_process_log
set message_type_cd = l_message_type_cd
,batch_status = l_status
,message_text = p_message_text
WHERE process_log_id = l_process_log_id;
END update_log_message;
update_log_message(p_folder_id => p_folder_id
,p_txn_entity_type => 'F'
,p_message_type_cd => p_rule_level
,p_message_text => l_message_text);
update_log_message(p_folder_id => p_folder_id
,p_transaction_id => p_transaction_id
,p_txn_entity_type => 'T'
,p_message_type_cd => p_rule_level
,p_message_text=> l_message_text);
update_log_message(p_folder_id => p_folder_id
,p_transaction_id => p_transaction_id
,p_entity_id => p_entity_id
,p_txn_entity_type => p_txn_entity_type
,p_budget_period_id => p_budget_period_id
,p_message_type_cd => p_rule_level
,p_message_text => l_message_text);