DBA Data[Home] [Help]

APPS.GHR_SES_CONV_PKG dependencies on HR_API

Line 214: l_log_text := ' Position Title : ' || ghr_api.get_position_title_pos(l_position_id,p_business_group_id);

210: END LOOP;
211: ---
212: --- Log Message
213: ---
214: l_log_text := ' Position Title : ' || ghr_api.get_position_title_pos(l_position_id,p_business_group_id);
215: l_log_text := substr(l_log_text || ', Position Number: ' ||
216: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id),1,2000);
217: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
218: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id),1,2000);

Line 216: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id),1,2000);

212: --- Log Message
213: ---
214: l_log_text := ' Position Title : ' || ghr_api.get_position_title_pos(l_position_id,p_business_group_id);
215: l_log_text := substr(l_log_text || ', Position Number: ' ||
216: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id),1,2000);
217: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
218: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id),1,2000);
219: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
220: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);

Line 218: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id),1,2000);

214: l_log_text := ' Position Title : ' || ghr_api.get_position_title_pos(l_position_id,p_business_group_id);
215: l_log_text := substr(l_log_text || ', Position Number: ' ||
216: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id),1,2000);
217: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
218: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id),1,2000);
219: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
220: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);
221:
222: IF SQL%NOTFOUND then

Line 362: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

358: else
359: l_log_text := ' Name : Vacant Position';
360: end if;
361: l_log_text := substr(l_log_text || ', Position Title : ' ||
362: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
363: l_log_text := substr(l_log_text || ', Position Number: ' ||
364: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
365: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
366: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

Line 364: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

360: end if;
361: l_log_text := substr(l_log_text || ', Position Title : ' ||
362: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
363: l_log_text := substr(l_log_text || ', Position Number: ' ||
364: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
365: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
366: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
367: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
368: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);

Line 366: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

362: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
363: l_log_text := substr(l_log_text || ', Position Number: ' ||
364: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
365: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
366: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
367: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
368: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);
369: l_log_text := substr(l_log_text || ', Effective Date : ' || to_char(l_check_date,'DD-MON-YYYY'),1,2000);
370:

Line 431: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

427: else
428: l_log_text := ' Name : Vacant Position';
429: end if;
430: l_log_text := substr(l_log_text || ', Position Title : ' ||
431: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
432: l_log_text := substr(l_log_text || ', Position Number: ' ||
433: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
434: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
435: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

Line 433: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

429: end if;
430: l_log_text := substr(l_log_text || ', Position Title : ' ||
431: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
432: l_log_text := substr(l_log_text || ', Position Number: ' ||
433: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
434: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
435: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
436: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
437: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);

Line 435: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

431: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
432: l_log_text := substr(l_log_text || ', Position Number: ' ||
433: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
434: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
435: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
436: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
437: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);
438: l_log_text := substr(l_log_text || ', Effective Date : ' || to_char(l_check_date,'DD-MON-YYYY'),1,2000);
439: