APPS.GHR_SES_CONV_PKG dependencies on GHR_PA_HISTORY

Line 73: FROM ghr_pa_history pah

69: pah.information4 , -- position_id
70: pah.information9 , -- grade_id
71: to_number(pah.information11) user_tab_id,
72: pah.effective_date
73: FROM ghr_pa_history pah
74: WHERE pah.table_name = 'PER_POSITION_EXTRA_INFO'
75: AND pah.information5 = 'GHR_US_POS_VALID_GRADE'
76: AND to_number(pah.information11) <> l_essl_tab_id
77: AND to_number(pah.information4) in

Line 110: FROM ghr_pa_history pah1

106: ---
107: ---
108: CURSOR cur_his_cut_off_date IS
109: SELECT 1
110: FROM ghr_pa_history pah1
111: WHERE table_name = 'PER_POSITION_EXTRA_INFO'
112: AND information5 = 'GHR_US_POS_VALID_GRADE'
113: and effective_date = l_effective_date
114: AND to_number(information4) = l_position_id

Line 126: l_hist_id ghr_pa_history.pa_history_id%type;

122: l_pay_plan per_grade_definitions.segment1%type;
123: l_grade_or_level per_grade_definitions.segment2%type;
124: l_posei_id per_position_extra_info.position_extra_info_id%type;
125: l_grd_id per_position_extra_info.poei_information5%type;
126: l_hist_id ghr_pa_history.pa_history_id%type;
127: l_his_eff_date ghr_pa_requests.effective_date%type;
128: l_counter NUMBER := 0;
129: l_counter1 NUMBER := 0;
130: --

Line 388: p_message_name => 'INS-GHR_PA_HISTORY',

384:
385: l_counter1 := l_counter1 + 1;
386: ghr_wgi_pkg.create_ghr_errorlog(
387: p_program_name => g_proc_name,
388: p_message_name => 'INS-GHR_PA_HISTORY',
389: p_log_text => l_log_text,
390: p_log_date => sysdate);
391:
392: END IF;

Line 397: p_message_name => 'INSERR-GHR_PA_HISTORY',

393: Exception when others then
394: l_log_text := substr(l_log_text || ', Message : ' || 'Record Not Inserted',1,2000);
395: ghr_wgi_pkg.create_ghr_errorlog(
396: p_program_name => g_proc_name,
397: p_message_name => 'INSERR-GHR_PA_HISTORY',
398: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
399: p_log_date => sysdate);
400: End;
401:

Line 440: UPDATE GHR_PA_HISTORY

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:
440: UPDATE GHR_PA_HISTORY
441: SET information11 = to_char(l_essl_tab_id)
442: WHERE pa_history_id = l_hist_id;
443:
444: IF SQL%NOTFOUND THEN

Line 448: p_message_name => 'UPDERR-GHR_PA_HISTORY',

444: IF SQL%NOTFOUND THEN
445: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
446: ghr_wgi_pkg.create_ghr_errorlog(
447: p_program_name => g_proc_name,
448: p_message_name => 'UPDERR-GHR_PA_HISTORY',
449: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
450: p_log_date => sysdate);
451: ELSE
452: l_counter := l_counter + 1;

Line 456: p_message_name => 'UPD-GHR_PA_HISTORY',

452: l_counter := l_counter + 1;
453: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
454: ghr_wgi_pkg.create_ghr_errorlog(
455: p_program_name => g_proc_name,
456: p_message_name => 'UPD-GHR_PA_HISTORY',
457: p_log_text => l_log_text,
458: p_log_date => sysdate);
459:
460: END IF;

Line 470: p_message_name => 'GHR_PA_HISTORY',

466:
467: IF l_counter1 = 0 AND l_counter = 0 THEN
468: ghr_wgi_pkg.create_ghr_errorlog(
469: p_program_name => g_proc_name,
470: p_message_name => 'GHR_PA_HISTORY',
471: p_log_text => 'Error : NO Valid History Position Records found for Update',
472: p_log_date => sysdate);
473: ELSE
474: ghr_wgi_pkg.create_ghr_errorlog(

Line 476: p_message_name => 'TOT-GHR_PA_HISTORY',

472: p_log_date => sysdate);
473: ELSE
474: ghr_wgi_pkg.create_ghr_errorlog(
475: p_program_name => g_proc_name,
476: p_message_name => 'TOT-GHR_PA_HISTORY',
477: p_log_text => 'Total Records inserted with SES equivalent plans are ' ||
478: to_char(l_counter1) || ' and Updates are ' || to_char(l_counter),
479: p_log_date => sysdate);
480: END IF;