DBA Data[Home] [Help]

APPS.GHR_SES_CONV_PKG dependencies on HR_API

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

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

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

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

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

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

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

351: else
352: l_log_text := ' Name : Vacant Position';
353: end if;
354: l_log_text := substr(l_log_text || ', Position Title : ' ||
355: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
356: l_log_text := substr(l_log_text || ', Position Number: ' ||
357: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
358: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
359: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

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

353: end if;
354: l_log_text := substr(l_log_text || ', Position Title : ' ||
355: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
356: l_log_text := substr(l_log_text || ', Position Number: ' ||
357: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
358: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
359: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
360: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
361: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);

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

355: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
356: l_log_text := substr(l_log_text || ', Position Number: ' ||
357: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
358: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
359: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
360: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
361: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);
362: l_log_text := substr(l_log_text || ', Effective Date : ' || to_char(l_check_date,'DD-MON-YYYY'),1,2000);
363:

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

417: else
418: l_log_text := ' Name : Vacant Position';
419: end if;
420: l_log_text := substr(l_log_text || ', Position Title : ' ||
421: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
422: l_log_text := substr(l_log_text || ', Position Number: ' ||
423: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
424: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
425: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);

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

419: end if;
420: l_log_text := substr(l_log_text || ', Position Title : ' ||
421: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
422: l_log_text := substr(l_log_text || ', Position Number: ' ||
423: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
424: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
425: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
426: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
427: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);

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

421: ghr_api.get_position_title_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
422: l_log_text := substr(l_log_text || ', Position Number: ' ||
423: ghr_api.get_position_desc_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
424: l_log_text := substr(l_log_text || ', Sequence Number: ' ||
425: ghr_api.get_position_sequence_no_pos(l_position_id,p_business_group_id,l_check_date),1,2000);
426: l_log_text := substr(l_log_text || ', From Pay Table : ' || l_from_user_tab_name,1,2000);
427: l_log_text := substr(l_log_text || ', To Pay Table : ' || 'ESSL',1,2000);
428: l_log_text := substr(l_log_text || ', Effective Date : ' || to_char(l_check_date,'DD-MON-YYYY'),1,2000);
429: