eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_HISTORY_API dependencies on GHR_HISTORY_API

Line 1: Package Body GHR_HISTORY_API as

1: Package Body GHR_HISTORY_API as
2: /* $Header: ghpahapi.pkb 120.0.12010000.2 2008/10/17 06:20:36 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------

Line 6: -- |--------------------------< >--------------------------|

2: /* $Header: ghpahapi.pkb 120.0.12010000.2 2008/10/17 06:20:36 vmididho ship $ */
3: --
4: --
5: -- ----------------------------------------------------------------------------
6: -- |--------------------------< >--------------------------|
7: -- ----------------------------------------------------------------------------
8: --
9: -- Package Global variables ---
10:

Line 631: if ( lower(p_table_name) = lower(ghr_history_api.g_peop_table) ) then

627: --
628: -- Remember IN OUT parameter IN values
629: l_hist_data := p_hist_data;
630:
631: if ( lower(p_table_name) = lower(ghr_history_api.g_peop_table) ) then
632: hr_utility.set_location(l_proc, 10);
633: ghr_history_fetch.fetch_people(p_person_id => p_person_id,
634: p_date_effective => p_date_effective,
635: p_altered_pa_request_id => p_altered_pa_request_id,

Line 644: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) ) then

640: p_result_code => p_result_code );
641:
642: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
643: p_history_data => p_hist_data );
644: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) ) then
645: hr_utility.set_location(l_proc, 15);
646: ghr_history_fetch.fetch_asgei(p_assignment_extra_info_id => p_table_pk_id,
647: p_date_effective => p_date_effective,
648: p_altered_pa_request_id => p_altered_pa_request_id,

Line 658: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgn_table) ) then

654: ghr_history_conv_rg.conv_asgnei_rg_to_hist_rg(
655: p_asgnei_data => l_asgei_data,
656: p_history_data => p_hist_data );
657:
658: elsif ( lower(p_table_name) = lower(ghr_history_api.g_asgn_table) ) then
659: hr_utility.set_location(l_proc, 25);
660: ghr_history_fetch.fetch_assignment (
661: p_assignment_id => p_table_pk_id,
662: p_date_effective => p_date_effective,

Line 674: elsif ( lower(p_table_name) = lower(ghr_history_api.g_peopei_table) ) then

670: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
671: p_assignment_data => l_asgn_data,
672: p_history_data => p_hist_data );
673:
674: elsif ( lower(p_table_name) = lower(ghr_history_api.g_peopei_table) ) then
675: hr_utility.set_location(l_proc, 35);
676: ghr_history_fetch.fetch_peopleei(
677: p_person_extra_info_id => p_table_pk_id,
678: p_date_effective => p_date_effective,

Line 690: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) ) then

686: ghr_history_conv_rg.conv_peopleei_rg_to_hist_rg(
687: p_people_ei_data => l_peopleei_data,
688: p_history_data => p_hist_data );
689:
690: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) ) then
691: hr_utility.set_location(l_proc, 35);
692: ghr_history_fetch.fetch_element_entry_value(
693: p_element_entry_value_id => p_table_pk_id,
694: p_date_effective => p_date_effective,

Line 706: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleent_table) ) then

702: ghr_history_conv_rg.conv_element_entval_rg_to_hist(
703: p_element_entval_data => l_element_entry_value_data,
704: p_history_data => p_hist_data );
705:
706: elsif ( lower(p_table_name) = lower(ghr_history_api.g_eleent_table) ) then
707: hr_utility.set_location(l_proc, 35);
708: ghr_history_fetch.fetch_element_entries(
709: p_element_entry_id => p_table_pk_id,
710: p_date_effective => p_date_effective,

Line 722: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posnei_table) ) then

718: ghr_history_conv_rg.conv_element_entry_rg_to_hist(
719: p_element_entries_data => l_element_entry_data,
720: p_history_data => p_hist_data );
721:
722: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posnei_table) ) then
723: hr_utility.set_location(l_proc, 35);
724: ghr_history_fetch.fetch_positionei(
725: p_position_extra_info_id => p_table_pk_id,
726: p_date_effective => p_date_effective,

Line 738: elsif ( lower(p_table_name) = lower(ghr_history_api.g_perana_table) ) then

734: ghr_history_conv_rg.conv_positionei_rg_to_hist_rg(
735: p_position_ei_data => l_posnei_data,
736: p_history_data => p_hist_data );
737:
738: elsif ( lower(p_table_name) = lower(ghr_history_api.g_perana_table) ) then
739: hr_utility.set_location(l_proc, 40);
740: ghr_history_fetch.fetch_person_analyses (
741: p_person_analysis_id => p_table_pk_id,
742: p_date_effective => p_date_effective,

Line 753: elsif ( lower(p_table_name) = lower(ghr_history_api.g_addres_table) ) then

749:
750: ghr_history_conv_rg.conv_peranalyses_rg_to_hist_rg(
751: p_peranalyses_data => l_peranalyses_data,
752: p_history_data => p_hist_data);
753: elsif ( lower(p_table_name) = lower(ghr_history_api.g_addres_table) ) then
754: hr_utility.set_location(l_proc, 40);
755: ghr_history_fetch.fetch_address(
756: p_address_id => p_table_pk_id,
757: p_date_effective => p_date_effective,

Line 768: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posn_table) ) then

764:
765: ghr_history_conv_rg.conv_addresses_rg_to_hist_rg(
766: p_addresses_data => l_address_data,
767: p_history_data => p_hist_data);
768: elsif ( lower(p_table_name) = lower(ghr_history_api.g_posn_table) ) then
769: hr_utility.set_location(l_proc, 40);
770: ghr_history_fetch.fetch_position(
771: p_position_id => p_table_pk_id,
772: p_date_effective => p_date_effective,

Line 1013: if (lower(g_operation_info(indx).table_name) in (lower(ghr_history_api.g_eleevl_table),

1009: end if;
1010:
1011: -- if this is a datetrack table, DML operation was an update, and it is not the correction SF52 then
1012: -- we may use Pre-update from global session
1013: if (lower(g_operation_info(indx).table_name) in (lower(ghr_history_api.g_eleevl_table),
1014: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),
1015: lower(ghr_history_api.g_posn_table),
1016: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND
1017: lower(g_operation_info(indx).operation) = 'update') then

Line 1014: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),

1010:
1011: -- if this is a datetrack table, DML operation was an update, and it is not the correction SF52 then
1012: -- we may use Pre-update from global session
1013: if (lower(g_operation_info(indx).table_name) in (lower(ghr_history_api.g_eleevl_table),
1014: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),
1015: lower(ghr_history_api.g_posn_table),
1016: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND
1017: lower(g_operation_info(indx).operation) = 'update') then
1018: hr_utility.set_location(l_proc || 'using pre_update', 9158);

Line 1015: lower(ghr_history_api.g_posn_table),

1011: -- if this is a datetrack table, DML operation was an update, and it is not the correction SF52 then
1012: -- we may use Pre-update from global session
1013: if (lower(g_operation_info(indx).table_name) in (lower(ghr_history_api.g_eleevl_table),
1014: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),
1015: lower(ghr_history_api.g_posn_table),
1016: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND
1017: lower(g_operation_info(indx).operation) = 'update') then
1018: hr_utility.set_location(l_proc || 'using pre_update', 9158);
1019: l_pre_record := g_pre_update(indx);

Line 1016: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND

1012: -- we may use Pre-update from global session
1013: if (lower(g_operation_info(indx).table_name) in (lower(ghr_history_api.g_eleevl_table),
1014: lower(ghr_history_api.g_asgn_table),lower(ghr_history_api.g_peop_table),
1015: lower(ghr_history_api.g_posn_table),
1016: lower(ghr_history_api.g_eleent_table)) AND l_session_var.noa_id_correct is NULL AND
1017: lower(g_operation_info(indx).operation) = 'update') then
1018: hr_utility.set_location(l_proc || 'using pre_update', 9158);
1019: l_pre_record := g_pre_update(indx);
1020: -- Pre-record found

Line 1054: l_dml_operation := ghr_history_api.g_ins_operation;

1050: IF l_return_status IS NULL THEN
1051: hr_utility.set_location(l_proc || 'Insert: history found.', 15);
1052: -- inserting with pre-values
1053: l_pre_values_flag := 'Y';
1054: l_dml_operation := ghr_history_api.g_ins_operation;
1055: ELSE
1056: hr_utility.set_location(l_proc || 'Insert: history NOT found.', 20);
1057: -- inserting with no pre-values
1058: l_dml_operation := ghr_history_api.g_ins_operation;

Line 1058: l_dml_operation := ghr_history_api.g_ins_operation;

1054: l_dml_operation := ghr_history_api.g_ins_operation;
1055: ELSE
1056: hr_utility.set_location(l_proc || 'Insert: history NOT found.', 20);
1057: -- inserting with no pre-values
1058: l_dml_operation := ghr_history_api.g_ins_operation;
1059: l_pre_values_flag := 'N';
1060: END IF;
1061: ELSIF g_operation_info(indx).operation = 'update' THEN
1062: -- set pre-record rg

Line 1069: l_dml_operation := ghr_history_api.g_upd_operation;

1065: hr_utility.set_location(l_proc || 'Update: history found.', 15);
1066: -- set Pre_record_rg and other flags
1067: -- updating with pre-values
1068: l_pre_values_flag := 'Y';
1069: l_dml_operation := ghr_history_api.g_upd_operation;
1070: ELSE
1071: hr_utility.set_location(l_proc || 'Update: history NOT found.', 20);
1072: -- updating with no pre-values
1073: l_dml_operation := ghr_history_api.g_upd_operation;

Line 1073: l_dml_operation := ghr_history_api.g_upd_operation;

1069: l_dml_operation := ghr_history_api.g_upd_operation;
1070: ELSE
1071: hr_utility.set_location(l_proc || 'Update: history NOT found.', 20);
1072: -- updating with no pre-values
1073: l_dml_operation := ghr_history_api.g_upd_operation;
1074: l_pre_values_flag := 'N';
1075: END IF;
1076: END IF;
1077:

Line 1091: If g_operation_info(indx).table_name in (ghr_history_api.g_eleevl_table,ghr_history_api.g_eleent_table )

1087:
1088: -- BUG # 5195518 added the below validation as if no record exists with the
1089: -- row id then no need of inserting into PA History.
1090: l_rec_avl := TRUE;
1091: If g_operation_info(indx).table_name in (ghr_history_api.g_eleevl_table,ghr_history_api.g_eleent_table )
1092: and l_return_status is not null then
1093: l_rec_avl := FALSE ;
1094: End if;
1095:

Line 1330: (lower(ghr_history_api.g_eleevl_table),

1326: );
1327: -- we stored pa_history id into local variable, put it into the record now.
1328: l_post_data.pa_history_id := pa_history_id;
1329: if lower(g_operation_info(indx).table_name) not in
1330: (lower(ghr_history_api.g_eleevl_table),
1331: lower(ghr_history_api.g_eleent_table),
1332: lower(ghr_history_api.g_perana_table)) then
1333: -- this is the normal case for most of the tables we are tracking.
1334:

Line 1331: lower(ghr_history_api.g_eleent_table),

1327: -- we stored pa_history id into local variable, put it into the record now.
1328: l_post_data.pa_history_id := pa_history_id;
1329: if lower(g_operation_info(indx).table_name) not in
1330: (lower(ghr_history_api.g_eleevl_table),
1331: lower(ghr_history_api.g_eleent_table),
1332: lower(ghr_history_api.g_perana_table)) then
1333: -- this is the normal case for most of the tables we are tracking.
1334:
1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);

Line 1332: lower(ghr_history_api.g_perana_table)) then

1328: l_post_data.pa_history_id := pa_history_id;
1329: if lower(g_operation_info(indx).table_name) not in
1330: (lower(ghr_history_api.g_eleevl_table),
1331: lower(ghr_history_api.g_eleent_table),
1332: lower(ghr_history_api.g_perana_table)) then
1333: -- this is the normal case for most of the tables we are tracking.
1334:
1335: hr_utility.set_location(l_proc || ' g_do_not_cascade ' || ghr_ses_conv_pkg.g_do_not_cascade, 76);
1336:

Line 1349: elsif (lower(g_operation_info(indx).table_name) = lower(ghr_history_api.g_eleevl_table)) then

1345: p_interv_on_eff_date => l_interv_on_eff_date,
1346: p_hist_data_as_of_date => l_hist_data_as_of_date
1347: );
1348: end if;
1349: elsif (lower(g_operation_info(indx).table_name) = lower(ghr_history_api.g_eleevl_table)) then
1350: -- PAY_ELEMENT_ENTRY_VALUES_F is a special case and needs to be handled differently.
1351: -- Cascade need not be performed for PAY_ELEMENT_ENTRY_VALUES_F,
1352: -- as it has only one column value so a record will be created only
1353: -- if the value changes thur sf52 or any other process which need not be

Line 1384: -- PAY_ELEMENT_ENTRIES_F, PER_PERSON_ANALYSES (ghr_history_api.g_eleent_table and g_perana_table)

1380: -- there were intervening records on the same date. So, re-apply the date-effective row from history.
1381: ghr_corr_canc_sf52.update_eleentval( p_hist_pre => l_eleevl_hist_data);
1382: end if;
1383: else
1384: -- PAY_ELEMENT_ENTRIES_F, PER_PERSON_ANALYSES (ghr_history_api.g_eleent_table and g_perana_table)
1385: -- need not be cascaded or updated with
1386: -- most recent values because they will only ever be inserted by non-correction sf52's. They
1387: -- will never be updated by non-correction sf52's. Correction's that update these tables
1388: -- are already handled correctly.

Line 1500: end GHR_HISTORY_API;

1496: end if;
1497: close c_getsessdate ;
1498: End get_session_date ;
1499:
1500: end GHR_HISTORY_API;