DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_LOG_PKG dependencies on HR_GENERAL

Line 150: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','D')

146: l_master_log_id := l_process_log_id; -- Transaction level Process Log ID
147: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id
148: ,p_module_cd => 'BUDGET_REALLOCATION'
149: ,p_txn_id => -1*p_transaction_id
150: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','D')
151: ,p_batch_start_date => sysdate
152: ,p_master_process_log_id => l_master_log_id
153: ,p_message_type_cd => 'START'
154: ,p_message_text => 'Process Started'

Line 162: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','R')

158: hr_utility.set_location('Inserted a row for Transaction-Donor Level '||l_proc,25);
159: pqh_process_log_api.create_process_log(p_process_log_id=> l_process_log_id
160: ,p_module_cd => 'BUDGET_REALLOCATION'
161: ,p_txn_id => -2*p_transaction_id
162: ,p_log_context => hr_general.decode_lookup('PQH_REALLOC_RECORD_TYPE','R')
163: ,p_batch_start_date => sysdate
164: ,p_master_process_log_id => l_master_log_id
165: ,p_message_type_cd => 'START'
166: ,p_message_text => 'Process Started'

Line 191: l_entity_name := hr_general.decode_position_latest_name(p_entity_id);

187: BEGIN
188: hr_utility.set_location('Entering '||l_proc,10);
189: -- Log context for entity is the entity name
190: IF p_bdgt_entity_type = 'POSITION' THEN
191: l_entity_name := hr_general.decode_position_latest_name(p_entity_id);
192: ELSIF p_bdgt_entity_type = 'ORGANIZATION' THEN
193: l_entity_name := hr_general.decode_organization(p_entity_id);
194: ELSIF p_bdgt_entity_type = 'JOB' THEN
195: l_entity_name := hr_general.decode_job(p_entity_id);

Line 193: l_entity_name := hr_general.decode_organization(p_entity_id);

189: -- Log context for entity is the entity name
190: IF p_bdgt_entity_type = 'POSITION' THEN
191: l_entity_name := hr_general.decode_position_latest_name(p_entity_id);
192: ELSIF p_bdgt_entity_type = 'ORGANIZATION' THEN
193: l_entity_name := hr_general.decode_organization(p_entity_id);
194: ELSIF p_bdgt_entity_type = 'JOB' THEN
195: l_entity_name := hr_general.decode_job(p_entity_id);
196: ELSIF p_bdgt_entity_type = 'GRADE' THEN
197: l_entity_name := hr_general.decode_grade(p_entity_id);

Line 195: l_entity_name := hr_general.decode_job(p_entity_id);

191: l_entity_name := hr_general.decode_position_latest_name(p_entity_id);
192: ELSIF p_bdgt_entity_type = 'ORGANIZATION' THEN
193: l_entity_name := hr_general.decode_organization(p_entity_id);
194: ELSIF p_bdgt_entity_type = 'JOB' THEN
195: l_entity_name := hr_general.decode_job(p_entity_id);
196: ELSIF p_bdgt_entity_type = 'GRADE' THEN
197: l_entity_name := hr_general.decode_grade(p_entity_id);
198: END IF;
199: l_master_log_id := get_process_log_id(p_folder_id => p_folder_id

Line 197: l_entity_name := hr_general.decode_grade(p_entity_id);

193: l_entity_name := hr_general.decode_organization(p_entity_id);
194: ELSIF p_bdgt_entity_type = 'JOB' THEN
195: l_entity_name := hr_general.decode_job(p_entity_id);
196: ELSIF p_bdgt_entity_type = 'GRADE' THEN
197: l_entity_name := hr_general.decode_grade(p_entity_id);
198: END IF;
199: l_master_log_id := get_process_log_id(p_folder_id => p_folder_id
200: ,p_transaction_id => p_transaction_id
201: ,p_entity_type => p_txn_entity_type);