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 767: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then

763:
764: l_proc varchar2(30):='Cascade_appl_table_data';
765: Begin
766: hr_utility.set_location( 'Entering : ' || l_proc, 10);
767: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
768: hr_utility.set_location( l_proc, 20);
769: Cascade_People(
770: p_pre_record => p_pre_record,
771: p_post_record => p_post_record,

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

772: p_cascade_type => p_cascade_type,
773: p_interv_on_eff_date => p_interv_on_eff_date,
774: p_hist_data_as_of_date => p_hist_data_as_of_date);
775:
776: elsif lower(p_table_name) = lower(ghr_history_api.g_asgn_table) then
777: hr_utility.set_location( l_proc, 30);
778: Cascade_asgn (
779: p_pre_record => p_pre_record,
780: p_post_record => p_post_record,

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

780: p_post_record => p_post_record,
781: p_cascade_type => p_cascade_type,
782: p_interv_on_eff_date => p_interv_on_eff_date,
783: p_hist_data_as_of_date => p_hist_data_as_of_date);
784: elsif lower(p_table_name) = lower(ghr_history_api.g_eleent_table) then
785: hr_utility.set_location( l_proc, 40);
786: -- this is already handled in cancel/correction procedures
787: -- retroactive actions need not cascade change in element_entry
788: null;

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

785: hr_utility.set_location( l_proc, 40);
786: -- this is already handled in cancel/correction procedures
787: -- retroactive actions need not cascade change in element_entry
788: null;
789: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
790: hr_utility.set_location( l_proc, 50);
791: -- this is already handled in cancel/correction procedures
792: -- retroactive actions need not cascade change in element_entry_values
793: null;

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

790: hr_utility.set_location( l_proc, 50);
791: -- this is already handled in cancel/correction procedures
792: -- retroactive actions need not cascade change in element_entry_values
793: null;
794: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
795: hr_utility.set_location( l_proc, 60);
796: Cascade_peopleei (
797: p_post_record => p_post_record);
798: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then

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

794: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
795: hr_utility.set_location( l_proc, 60);
796: Cascade_peopleei (
797: p_post_record => p_post_record);
798: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
799: hr_utility.set_location( l_proc, 70);
800: Cascade_asgnei (
801: p_post_record => p_post_record);
802: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then

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

798: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
799: hr_utility.set_location( l_proc, 70);
800: Cascade_asgnei (
801: p_post_record => p_post_record);
802: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
803: hr_utility.set_location( l_proc, 80);
804: Cascade_addresses (
805: p_post_record => p_post_record);
806: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then

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

802: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
803: hr_utility.set_location( l_proc, 80);
804: Cascade_addresses (
805: p_post_record => p_post_record);
806: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
807: hr_utility.set_location( l_proc, 90);
808: Cascade_posnei (
809: p_post_record => p_post_record);
810: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then

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

806: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
807: hr_utility.set_location( l_proc, 90);
808: Cascade_posnei (
809: p_post_record => p_post_record);
810: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
811: hr_utility.set_location( l_proc, 90);
812: /*
813: Cascade_posn (
814: p_post_record => p_post_record);

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

819: p_cascade_type => p_cascade_type,
820: p_interv_on_eff_date => p_interv_on_eff_date,
821: p_hist_data_as_of_date => p_hist_data_as_of_date);
822:
823: elsif lower(p_table_name) in (lower(ghr_history_api.g_perana_table)) then
824: -- This table need not cascade.
825: hr_utility.set_location( l_proc, 95);
826: Cascade_perana (
827: p_post_record => p_post_record);

Line 1184: p_table_name => ghr_history_api.g_peopei_table,

1180: -- This procedure will fetch
1181: -- the most recent record from history and update the database.
1182: hr_utility.set_location( l_proc, 20);
1183: Fetch_most_recent_record(
1184: p_table_name => ghr_history_api.g_peopei_table,
1185: p_table_pk_id => p_post_record.information1,
1186: p_person_id => p_post_record.person_id,
1187: p_history_data => l_hist_peopleei_data,
1188: p_result_code => l_result_code);

Line 1260: p_table_name => ghr_history_api.g_asgnei_table,

1256: -- This procedure will fetch
1257: -- the most recent record from history and update the database.
1258: hr_utility.set_location( l_proc, 20);
1259: Fetch_most_recent_record(
1260: p_table_name => ghr_history_api.g_asgnei_table,
1261: p_table_pk_id => p_post_record.information1,
1262: p_person_id => p_post_record.person_id,
1263: p_history_data => l_hist_asgnei_data,
1264: p_result_code => l_result_code);

Line 1333: p_table_name => ghr_history_api.g_posnei_table,

1329: -- This procedure will fetch
1330: -- the most recent record from history and update the database.
1331: hr_utility.set_location( l_proc, 20);
1332: Fetch_most_recent_record(
1333: p_table_name => ghr_history_api.g_posnei_table,
1334: p_table_pk_id => p_post_record.information1,
1335: p_person_id => p_post_record.person_id,
1336: p_history_data => l_hist_posnei_data,
1337: p_result_code => l_result_code);

Line 1346: GHR_HISTORY_API.get_session_date(l_curr_sess_date);

1342: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1343: hr_utility.raise_error;
1344: else
1345: hr_utility.set_location( l_proc, 40);
1346: GHR_HISTORY_API.get_session_date(l_curr_sess_date);
1347:
1348: ghr_history_conv_rg.Conv_to_positionei_rg(
1349: p_position_ei_data => l_posnei_data,
1350: p_history_data => l_hist_posnei_data);

Line 1420: p_table_name => ghr_history_api.g_posn_table,

1416: -- This procedure will fetch
1417: -- the most recent record from history and update the database.
1418: hr_utility.set_location( l_proc, 20);
1419: Fetch_most_recent_record(
1420: p_table_name => ghr_history_api.g_posn_table,
1421: p_table_pk_id => p_post_record.information1,
1422: p_person_id => p_post_record.person_id,
1423: p_history_data => l_hist_posn_data,
1424: p_result_code => l_result_code);

Line 1645: p_table_name => ghr_history_api.g_addres_table,

1641: -- This procedure will fetch
1642: -- the most recent record from history and update the database.
1643: hr_utility.set_location( l_proc, 20);
1644: Fetch_most_recent_record(
1645: p_table_name => ghr_history_api.g_addres_table,
1646: p_table_pk_id => p_post_record.information1,
1647: p_person_id => p_post_record.person_id,
1648: p_history_data => l_hist_addresses_data,
1649: p_result_code => l_result_code);

Line 1716: p_table_name => ghr_history_api.g_perana_table,

1712: -- This procedure will fetch
1713: -- the most recent record from history and update the database.
1714: hr_utility.set_location( l_proc, 20);
1715: Fetch_most_recent_record(
1716: p_table_name => ghr_history_api.g_perana_table,
1717: p_table_pk_id => p_post_record.information1,
1718: p_person_id => p_post_record.person_id,
1719: p_history_data => l_hist_perana_data,
1720: p_result_code => l_result_code);

Line 2780: l_session_var ghr_history_api.g_session_var_type;

2776: from per_addresses
2777: where address_id = p_addr_data.address_id;
2778:
2779: l_addr_data per_addresses%rowtype;
2780: l_session_var ghr_history_api.g_session_var_type;
2781: l_proc varchar2(30):='correct_addresses_row';
2782:
2783: Begin
2784: hr_utility.set_location(' entering : ' || l_proc, 10);

Line 2788: ghr_history_api.get_g_session_var( l_session_var);

2784: hr_utility.set_location(' entering : ' || l_proc, 10);
2785: --Initialise Local Variables
2786: l_addr_data := p_addr_data;
2787: --
2788: ghr_history_api.get_g_session_var( l_session_var);
2789: hr_utility.set_location(l_proc, 20);
2790:
2791: open c_addr;
2792: fetch c_addr into p_addr_data.object_version_number;

Line 2871: l_session_var ghr_history_api.g_session_var_type;

2867: from per_person_analyses
2868: where person_analysis_id = p_perana_data.person_analysis_id;
2869:
2870: l_perana_data per_person_analyses%rowtype;
2871: l_session_var ghr_history_api.g_session_var_type;
2872: l_proc varchar2(30):='correct_perana_row';
2873:
2874: Begin
2875: hr_utility.set_location(' entering : ' || l_proc, 10);

Line 2880: ghr_history_api.get_g_session_var( l_session_var);

2876: -- Initialise Local Variables
2877: l_perana_data := p_perana_data;
2878: --
2879:
2880: ghr_history_api.get_g_session_var( l_session_var);
2881: hr_utility.set_location(l_proc, 20);
2882:
2883: open c_perana;
2884: fetch c_perana into p_perana_data.object_version_number;

Line 3014: IF UPPER(p_post_record.table_name) = ghr_history_api.g_peop_table THEN

3010: --BUG # 14625196 Added as lastname need to be updated and last name is stored
3011: -- in information6 of GHR_PA_HISTORY. with out this last name not getting
3012: -- updated in PER_ALL_PEOPLE_F
3013:
3014: IF UPPER(p_post_record.table_name) = ghr_history_api.g_peop_table THEN
3015: cascade_field_value
3016: (p_pre_field => p_pre_record.information6,
3017: p_post_field => p_post_record.information6,
3018: p_apply_field => p_apply_record.information6,

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

3021: END IF;
3022:
3023: hr_utility.set_location(l_proc,25);
3024: ---Added for Bug 3413335
3025: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3026: hr_utility.set_location(l_proc,34);
3027: cascade_field_value
3028: (p_pre_field => p_pre_record.information7,
3029: p_post_field => p_post_record.information7,

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

3043: END IF;
3044:
3045: hr_utility.set_location(l_proc,30);
3046: ---Added for Bug 3413335
3047: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3048: hr_utility.set_location(l_proc,34);
3049: cascade_field_value
3050: (p_pre_field => p_pre_record.information8,
3051: p_post_field => p_post_record.information8,

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

3063: );
3064: END IF;
3065: END IF;
3066:
3067: if (p_post_record.table_name = ghr_history_api.g_addres_table) then
3068: if (p_true_false(9) = FALSE) then
3069: null;
3070: else
3071: If (nvl(p_pre_record.information9,hr_api.g_varchar2) <> nvl(p_post_record.information9,hr_api.g_varchar2) or

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

3111: end if;
3112: else
3113: hr_utility.set_location(l_proc,35);
3114: ---Added for Bug 3413335
3115: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3116: hr_utility.set_location(l_proc,34);
3117: cascade_field_value
3118: (p_pre_field => p_pre_record.information9,
3119: p_post_field => p_post_record.information9,

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

3133: END IF;
3134:
3135: hr_utility.set_location(l_proc,40);
3136: ---Added for Bug 3413335
3137: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3138: hr_utility.set_location(l_proc,44);
3139: cascade_field_value
3140: (p_pre_field => p_pre_record.information10,
3141: p_post_field => p_post_record.information10,

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

3154: END IF;
3155: END IF;
3156:
3157: -- Start processing for Bug 3413335
3158: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3159: hr_utility.set_location(l_proc,45);
3160: cascade_field_value
3161: (p_pre_field => p_pre_record.information11,
3162: p_post_field => p_post_record.information11,

Line 4209: ghr_history_api.fetch_history_info(

4205: l_history_data := p_history_data;
4206: l_result_code := p_result_code;
4207: --
4208:
4209: ghr_history_api.fetch_history_info(
4210: p_table_name => p_table_name,
4211: p_table_pk_id => p_table_pk_id,
4212: p_person_id => p_person_id,
4213: p_date_effective => l_date_effective,