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_CASCADE dependencies on GHR_HISTORY_API

Line 169: l_session_var ghr_history_api.g_session_var_type;

165: p_interv_on_eff_date out nocopy boolean,
166: p_hist_data_as_of_date out nocopy ghr_pa_history%rowtype )
167: is
168:
169: l_session_var ghr_history_api.g_session_var_type;
170: l_proc varchar2(72) := 'Cascade_History_data';
171: l_record_data ghr_pa_history%rowtype;
172: l_true_false ghr_history_cascade.condition_rg_type;
173: l_stop boolean;

Line 295: ghr_history_api.get_g_session_var( l_session_var);

291:
292: p_interv_on_eff_date := FALSE;
293: p_interv_on_table := FALSE;
294:
295: ghr_history_api.get_g_session_var( l_session_var);
296:
297: -- Initialize the true_false table with TRUE
298: -- Since only information 4 thru' information101 can be cascaded
299: hr_utility.set_location(l_proc,10);

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

757:
758: l_proc varchar2(30):='Cascade_appl_table_data';
759: Begin
760: hr_utility.set_location( 'Entering : ' || l_proc, 10);
761: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
762: hr_utility.set_location( l_proc, 20);
763: Cascade_People(
764: p_pre_record => p_pre_record,
765: p_post_record => p_post_record,

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

766: p_cascade_type => p_cascade_type,
767: p_interv_on_eff_date => p_interv_on_eff_date,
768: p_hist_data_as_of_date => p_hist_data_as_of_date);
769:
770: elsif lower(p_table_name) = lower(ghr_history_api.g_asgn_table) then
771: hr_utility.set_location( l_proc, 30);
772: Cascade_asgn (
773: p_pre_record => p_pre_record,
774: p_post_record => p_post_record,

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

774: p_post_record => p_post_record,
775: p_cascade_type => p_cascade_type,
776: p_interv_on_eff_date => p_interv_on_eff_date,
777: p_hist_data_as_of_date => p_hist_data_as_of_date);
778: elsif lower(p_table_name) = lower(ghr_history_api.g_eleent_table) then
779: hr_utility.set_location( l_proc, 40);
780: -- this is already handled in cancel/correction procedures
781: -- retroactive actions need not cascade change in element_entry
782: null;

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

779: hr_utility.set_location( l_proc, 40);
780: -- this is already handled in cancel/correction procedures
781: -- retroactive actions need not cascade change in element_entry
782: null;
783: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
784: hr_utility.set_location( l_proc, 50);
785: -- this is already handled in cancel/correction procedures
786: -- retroactive actions need not cascade change in element_entry_values
787: null;

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

784: hr_utility.set_location( l_proc, 50);
785: -- this is already handled in cancel/correction procedures
786: -- retroactive actions need not cascade change in element_entry_values
787: null;
788: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
789: hr_utility.set_location( l_proc, 60);
790: Cascade_peopleei (
791: p_post_record => p_post_record);
792: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then

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

788: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
789: hr_utility.set_location( l_proc, 60);
790: Cascade_peopleei (
791: p_post_record => p_post_record);
792: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
793: hr_utility.set_location( l_proc, 70);
794: Cascade_asgnei (
795: p_post_record => p_post_record);
796: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then

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

792: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
793: hr_utility.set_location( l_proc, 70);
794: Cascade_asgnei (
795: p_post_record => p_post_record);
796: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
797: hr_utility.set_location( l_proc, 80);
798: Cascade_addresses (
799: p_post_record => p_post_record);
800: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then

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

796: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
797: hr_utility.set_location( l_proc, 80);
798: Cascade_addresses (
799: p_post_record => p_post_record);
800: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
801: hr_utility.set_location( l_proc, 90);
802: Cascade_posnei (
803: p_post_record => p_post_record);
804: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then

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

800: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
801: hr_utility.set_location( l_proc, 90);
802: Cascade_posnei (
803: p_post_record => p_post_record);
804: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
805: hr_utility.set_location( l_proc, 90);
806: /*
807: Cascade_posn (
808: p_post_record => p_post_record);

Line 817: elsif lower(p_table_name) in (lower(ghr_history_api.g_perana_table)) then

813: p_cascade_type => p_cascade_type,
814: p_interv_on_eff_date => p_interv_on_eff_date,
815: p_hist_data_as_of_date => p_hist_data_as_of_date);
816:
817: elsif lower(p_table_name) in (lower(ghr_history_api.g_perana_table)) then
818: -- This table need not cascade.
819: hr_utility.set_location( l_proc, 95);
820: Cascade_perana (
821: p_post_record => p_post_record);

Line 1178: p_table_name => ghr_history_api.g_peopei_table,

1174: -- This procedure will fetch
1175: -- the most recent record from history and update the database.
1176: hr_utility.set_location( l_proc, 20);
1177: Fetch_most_recent_record(
1178: p_table_name => ghr_history_api.g_peopei_table,
1179: p_table_pk_id => p_post_record.information1,
1180: p_person_id => p_post_record.person_id,
1181: p_history_data => l_hist_peopleei_data,
1182: p_result_code => l_result_code);

Line 1254: p_table_name => ghr_history_api.g_asgnei_table,

1250: -- This procedure will fetch
1251: -- the most recent record from history and update the database.
1252: hr_utility.set_location( l_proc, 20);
1253: Fetch_most_recent_record(
1254: p_table_name => ghr_history_api.g_asgnei_table,
1255: p_table_pk_id => p_post_record.information1,
1256: p_person_id => p_post_record.person_id,
1257: p_history_data => l_hist_asgnei_data,
1258: p_result_code => l_result_code);

Line 1325: p_table_name => ghr_history_api.g_posnei_table,

1321: -- This procedure will fetch
1322: -- the most recent record from history and update the database.
1323: hr_utility.set_location( l_proc, 20);
1324: Fetch_most_recent_record(
1325: p_table_name => ghr_history_api.g_posnei_table,
1326: p_table_pk_id => p_post_record.information1,
1327: p_person_id => p_post_record.person_id,
1328: p_history_data => l_hist_posnei_data,
1329: p_result_code => l_result_code);

Line 1397: p_table_name => ghr_history_api.g_posn_table,

1393: -- This procedure will fetch
1394: -- the most recent record from history and update the database.
1395: hr_utility.set_location( l_proc, 20);
1396: Fetch_most_recent_record(
1397: p_table_name => ghr_history_api.g_posn_table,
1398: p_table_pk_id => p_post_record.information1,
1399: p_person_id => p_post_record.person_id,
1400: p_history_data => l_hist_posn_data,
1401: p_result_code => l_result_code);

Line 1622: p_table_name => ghr_history_api.g_addres_table,

1618: -- This procedure will fetch
1619: -- the most recent record from history and update the database.
1620: hr_utility.set_location( l_proc, 20);
1621: Fetch_most_recent_record(
1622: p_table_name => ghr_history_api.g_addres_table,
1623: p_table_pk_id => p_post_record.information1,
1624: p_person_id => p_post_record.person_id,
1625: p_history_data => l_hist_addresses_data,
1626: p_result_code => l_result_code);

Line 1693: p_table_name => ghr_history_api.g_perana_table,

1689: -- This procedure will fetch
1690: -- the most recent record from history and update the database.
1691: hr_utility.set_location( l_proc, 20);
1692: Fetch_most_recent_record(
1693: p_table_name => ghr_history_api.g_perana_table,
1694: p_table_pk_id => p_post_record.information1,
1695: p_person_id => p_post_record.person_id,
1696: p_history_data => l_hist_perana_data,
1697: p_result_code => l_result_code);

Line 2754: l_session_var ghr_history_api.g_session_var_type;

2750: from per_addresses
2751: where address_id = p_addr_data.address_id;
2752:
2753: l_addr_data per_addresses%rowtype;
2754: l_session_var ghr_history_api.g_session_var_type;
2755: l_proc varchar2(30):='correct_addresses_row';
2756:
2757: Begin
2758: hr_utility.set_location(' entering : ' || l_proc, 10);

Line 2762: ghr_history_api.get_g_session_var( l_session_var);

2758: hr_utility.set_location(' entering : ' || l_proc, 10);
2759: --Initialise Local Variables
2760: l_addr_data := p_addr_data;
2761: --
2762: ghr_history_api.get_g_session_var( l_session_var);
2763: hr_utility.set_location(l_proc, 20);
2764:
2765: open c_addr;
2766: fetch c_addr into p_addr_data.object_version_number;

Line 2845: l_session_var ghr_history_api.g_session_var_type;

2841: from per_person_analyses
2842: where person_analysis_id = p_perana_data.person_analysis_id;
2843:
2844: l_perana_data per_person_analyses%rowtype;
2845: l_session_var ghr_history_api.g_session_var_type;
2846: l_proc varchar2(30):='correct_perana_row';
2847:
2848: Begin
2849: hr_utility.set_location(' entering : ' || l_proc, 10);

Line 2854: ghr_history_api.get_g_session_var( l_session_var);

2850: -- Initialise Local Variables
2851: l_perana_data := p_perana_data;
2852: --
2853:
2854: ghr_history_api.get_g_session_var( l_session_var);
2855: hr_utility.set_location(l_proc, 20);
2856:
2857: open c_perana;
2858: fetch c_perana into p_perana_data.object_version_number;

Line 2992: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN

2988: ); */ -- Bug 1161542
2989:
2990: hr_utility.set_location(l_proc,25);
2991: ---Added for Bug 3413335
2992: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
2993: hr_utility.set_location(l_proc,34);
2994: cascade_field_value
2995: (p_pre_field => p_pre_record.information7,
2996: p_post_field => p_post_record.information7,

Line 3014: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN

3010: END IF;
3011:
3012: hr_utility.set_location(l_proc,30);
3013: ---Added for Bug 3413335
3014: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3015: hr_utility.set_location(l_proc,34);
3016: cascade_field_value
3017: (p_pre_field => p_pre_record.information8,
3018: p_post_field => p_post_record.information8,

Line 3034: if (p_post_record.table_name = ghr_history_api.g_addres_table) then

3030: );
3031: END IF;
3032: END IF;
3033:
3034: if (p_post_record.table_name = ghr_history_api.g_addres_table) then
3035: if (p_true_false(9) = FALSE) then
3036: null;
3037: else
3038: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or

Line 3082: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN

3078: end if;
3079: else
3080: hr_utility.set_location(l_proc,35);
3081: ---Added for Bug 3413335
3082: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3083: hr_utility.set_location(l_proc,34);
3084: cascade_field_value
3085: (p_pre_field => p_pre_record.information9,
3086: p_post_field => p_post_record.information9,

Line 3104: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN

3100: END IF;
3101:
3102: hr_utility.set_location(l_proc,40);
3103: ---Added for Bug 3413335
3104: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3105: hr_utility.set_location(l_proc,44);
3106: cascade_field_value
3107: (p_pre_field => p_pre_record.information10,
3108: p_post_field => p_post_record.information10,

Line 3125: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN

3121: END IF;
3122: END IF;
3123:
3124: -- Start processing for Bug 3413335
3125: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3126: hr_utility.set_location(l_proc,45);
3127: cascade_field_value
3128: (p_pre_field => p_pre_record.information11,
3129: p_post_field => p_post_record.information11,

Line 4176: ghr_history_api.fetch_history_info(

4172: l_history_data := p_history_data;
4173: l_result_code := p_result_code;
4174: --
4175:
4176: ghr_history_api.fetch_history_info(
4177: p_table_name => p_table_name,
4178: p_table_pk_id => p_table_pk_id,
4179: p_person_id => p_person_id,
4180: p_date_effective => l_date_effective,