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.

[Home] [Help]

APPS.GHR_SS_ASG_EIT dependencies on GHR_HISTORY_API

Line 33: l_session_var ghr_history_api.g_session_var_type;

29: ,p_assignment_id in number
30: ,p_information_type in varchar2) IS
31:
32: l_proc varchar2(30) := 'history_ins_process';
33: l_session_var ghr_history_api.g_session_var_type;
34: v_is_ghr_setup_avl varchar2(10);
35: r_setup_cnt number;
36: l_row_touched boolean;
37: indx binary_integer;

Line 68: ghr_history_api.get_g_session_var(l_session_var);

64: END IF;
65: CLOSE c_fed_setup_avl;
66:
67: IF v_is_ghr_setup_avl = 'TRUE' THEN
68: ghr_history_api.get_g_session_var(l_session_var);
69:
70: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
71:
72: l_session_var.assignment_id := p_assignment_id;

Line 73: ghr_history_api.get_session_date( l_session_var.date_effective);

69:
70: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
71:
72: l_session_var.assignment_id := p_assignment_id;
73: ghr_history_api.get_session_date( l_session_var.date_effective);
74: ghr_history_api.set_g_session_var(l_session_var);
75:
76: validate_telework_det(p_assignment_extra_info_id);
77:

Line 74: ghr_history_api.set_g_session_var(l_session_var);

70: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
71:
72: l_session_var.assignment_id := p_assignment_id;
73: ghr_history_api.get_session_date( l_session_var.date_effective);
74: ghr_history_api.set_g_session_var(l_session_var);
75:
76: validate_telework_det(p_assignment_extra_info_id);
77:
78: open get_row_id;

Line 82: l_row_touched := ghr_history_api.row_already_touched(l_row_id);

78: open get_row_id;
79: fetch get_row_id into l_row_id;
80: close get_row_id;
81:
82: l_row_touched := ghr_history_api.row_already_touched(l_row_id);
83: IF l_row_touched then
84: hr_utility.set_location(l_proc, 15);
85: null;
86: else

Line 87: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',

83: IF l_row_touched then
84: hr_utility.set_location(l_proc, 15);
85: null;
86: else
87: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
88: p_table_pk_id => p_assignment_extra_info_id,
89: p_operation => 'insert',
90: p_row_id => l_row_id);
91: end if;

Line 93: ghr_history_api.post_update_process;

89: p_operation => 'insert',
90: p_row_id => l_row_id);
91: end if;
92:
93: ghr_history_api.post_update_process;
94: ghr_history_api.reinit_g_session_var;
95: END IF;
96: END IF;
97:

Line 94: ghr_history_api.reinit_g_session_var;

90: p_row_id => l_row_id);
91: end if;
92:
93: ghr_history_api.post_update_process;
94: ghr_history_api.reinit_g_session_var;
95: END IF;
96: END IF;
97:
98: END INS_PA_HISTORY_PROC;

Line 130: l_session_var ghr_history_api.g_session_var_type;

126: ,p_assignment_id in number
127: ,p_information_type in varchar2) IS
128:
129: l_proc varchar2(30) := 'history_ins_process';
130: l_session_var ghr_history_api.g_session_var_type;
131: v_is_ghr_setup_avl varchar2(10);
132: r_setup_cnt number;
133: l_row_touched boolean;
134: indx binary_integer;

Line 164: ghr_history_api.get_g_session_var(l_session_var);

160: END IF;
161: CLOSE c_fed_setup_avl;
162:
163: IF v_is_ghr_setup_avl = 'TRUE' THEN
164: ghr_history_api.get_g_session_var(l_session_var);
165:
166: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
167:
168: l_session_var.assignment_id := p_assignment_id;

Line 169: ghr_history_api.get_session_date( l_session_var.date_effective);

165:
166: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
167:
168: l_session_var.assignment_id := p_assignment_id;
169: ghr_history_api.get_session_date( l_session_var.date_effective);
170: ghr_history_api.set_g_session_var(l_session_var);
171:
172: validate_telework_det(p_assignment_extra_info_id);
173:

Line 170: ghr_history_api.set_g_session_var(l_session_var);

166: IF l_session_var.program_name is null and p_information_type = 'GHR_US_ASG_TELEWORK_INFO' THEN
167:
168: l_session_var.assignment_id := p_assignment_id;
169: ghr_history_api.get_session_date( l_session_var.date_effective);
170: ghr_history_api.set_g_session_var(l_session_var);
171:
172: validate_telework_det(p_assignment_extra_info_id);
173:
174: open get_row_id;

Line 178: l_row_touched := ghr_history_api.row_already_touched(l_row_id);

174: open get_row_id;
175: fetch get_row_id into l_row_id;
176: close get_row_id;
177:
178: l_row_touched := ghr_history_api.row_already_touched(l_row_id);
179:
180: IF l_row_touched then
181: hr_utility.set_location(l_proc, 15);
182: null;

Line 184: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',

180: IF l_row_touched then
181: hr_utility.set_location(l_proc, 15);
182: null;
183: else
184: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
185: p_table_pk_id => p_assignment_extra_info_id,
186: p_operation => 'update',
187: p_row_id => l_row_id);
188: end if;

Line 190: ghr_history_api.post_update_process;

186: p_operation => 'update',
187: p_row_id => l_row_id);
188: end if;
189:
190: ghr_history_api.post_update_process;
191: ghr_history_api.reinit_g_session_var;
192: END IF;
193: END IF;
194:

Line 191: ghr_history_api.reinit_g_session_var;

187: p_row_id => l_row_id);
188: end if;
189:
190: ghr_history_api.post_update_process;
191: ghr_history_api.reinit_g_session_var;
192: END IF;
193: END IF;
194:
195: END UPD_PA_HISTORY_PROC;