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 381: p_message_name => 'INS-GHR_PA_HISTORY',

377:
378: l_counter1 := l_counter1 + 1;
379: ghr_wgi_pkg.create_ghr_errorlog(
380: p_program_name => g_proc_name,
381: p_message_name => 'INS-GHR_PA_HISTORY',
382: p_log_text => l_log_text,
383: p_log_date => sysdate);
384:
385: END IF;

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

386: Exception when others then
387: l_log_text := substr(l_log_text || ', Message : ' || 'Record Not Inserted',1,2000);
388: ghr_wgi_pkg.create_ghr_errorlog(
389: p_program_name => g_proc_name,
390: p_message_name => 'INSERR-GHR_PA_HISTORY',
391: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
392: p_log_date => sysdate);
393: End;
394:

Line 430: UPDATE GHR_PA_HISTORY

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:
430: UPDATE GHR_PA_HISTORY
431: SET information11 = to_char(l_essl_tab_id)
432: WHERE pa_history_id = l_hist_id;
433:
434: IF SQL%NOTFOUND THEN

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

434: IF SQL%NOTFOUND THEN
435: l_log_text := substr(l_log_text || ', Message : ' || 'ERROR NOT UPDATED ,',1,2000);
436: ghr_wgi_pkg.create_ghr_errorlog(
437: p_program_name => g_proc_name,
438: p_message_name => 'UPDERR-GHR_PA_HISTORY',
439: p_log_text => substr(l_log_text || 'DB ERROR is : ' || SQLERRM,1,2000),
440: p_log_date => sysdate);
441: ELSE
442: l_counter := l_counter + 1;

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

442: l_counter := l_counter + 1;
443: l_log_text := substr(l_log_text || ', Message : ' || 'Updated Successful ',1,2000);
444: ghr_wgi_pkg.create_ghr_errorlog(
445: p_program_name => g_proc_name,
446: p_message_name => 'UPD-GHR_PA_HISTORY',
447: p_log_text => l_log_text,
448: p_log_date => sysdate);
449:
450: END IF;

Line 460: p_message_name => 'GHR_PA_HISTORY',

456:
457: IF l_counter1 = 0 AND l_counter = 0 THEN
458: ghr_wgi_pkg.create_ghr_errorlog(
459: p_program_name => g_proc_name,
460: p_message_name => 'GHR_PA_HISTORY',
461: p_log_text => 'Error : NO Valid History Position Records found for Update',
462: p_log_date => sysdate);
463: ELSE
464: ghr_wgi_pkg.create_ghr_errorlog(

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

462: p_log_date => sysdate);
463: ELSE
464: ghr_wgi_pkg.create_ghr_errorlog(
465: p_program_name => g_proc_name,
466: p_message_name => 'TOT-GHR_PA_HISTORY',
467: p_log_text => 'Total Records inserted with SES equivalent plans are ' ||
468: to_char(l_counter1) || ' and Updates are ' || to_char(l_counter),
469: p_log_date => sysdate);
470: END IF;