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.PAY_RFI_SHD dependencies on PAY_RFI_SHD

Line 1: Package Body pay_rfi_shd as

1: Package Body pay_rfi_shd as
2: /* $Header: pyrfirhi.pkb 120.0 2005/05/29 08:19 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' pay_rfi_shd.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_rfi_shd.'; -- Global package name
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< return_api_dml_status >-------------------------|
12: -- ----------------------------------------------------------------------------

Line 90: pay_rfi_shd.g_old_rec.report_format_item_id and

86: --
87: l_fct_ret := false;
88: Else
89: If (p_report_format_item_id =
90: pay_rfi_shd.g_old_rec.report_format_item_id and
91: p_object_version_number =
92: pay_rfi_shd.g_old_rec.object_version_number
93: ) Then
94: --

Line 92: pay_rfi_shd.g_old_rec.object_version_number

88: Else
89: If (p_report_format_item_id =
90: pay_rfi_shd.g_old_rec.report_format_item_id and
91: p_object_version_number =
92: pay_rfi_shd.g_old_rec.object_version_number
93: ) Then
94: --
95: -- The g_old_rec is current therefore we must
96: -- set the returning function to true

Line 104: Fetch C_Sel1 Into pay_rfi_shd.g_old_rec;

100: --
101: -- Select the current row
102: --
103: Open C_Sel1;
104: Fetch C_Sel1 Into pay_rfi_shd.g_old_rec;
105: If C_Sel1%notfound Then
106: Close C_Sel1;
107: --
108: -- The primary key is invalid therefore we must error

Line 115: <> pay_rfi_shd.g_old_rec.object_version_number) Then

111: fnd_message.raise_error;
112: End If;
113: Close C_Sel1;
114: If (p_object_version_number
115: <> pay_rfi_shd.g_old_rec.object_version_number) Then
116: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
117: fnd_message.raise_error;
118: End If;
119:

Line 120: pay_rfi_shd.g_old_rec.report_format_mapping_id

116: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
117: fnd_message.raise_error;
118: End If;
119:
120: pay_rfi_shd.g_old_rec.report_format_mapping_id
121: := pay_rfm_shd.get_report_format_mapping_id
122: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
123: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
124: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );

Line 122: ( p_report_type => pay_rfi_shd.g_old_rec.report_type

118: End If;
119:
120: pay_rfi_shd.g_old_rec.report_format_mapping_id
121: := pay_rfm_shd.get_report_format_mapping_id
122: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
123: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
124: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
125:
126: l_fct_ret := true;

Line 123: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier

119:
120: pay_rfi_shd.g_old_rec.report_format_mapping_id
121: := pay_rfm_shd.get_report_format_mapping_id
122: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
123: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
124: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
125:
126: l_fct_ret := true;
127: End If;

Line 124: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );

120: pay_rfi_shd.g_old_rec.report_format_mapping_id
121: := pay_rfm_shd.get_report_format_mapping_id
122: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
123: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
124: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
125:
126: l_fct_ret := true;
127: End If;
128: End If;

Line 258: pay_rfi_shd.g_api_dml := true; -- Set the api dml status

254: ,p_base_key_value => p_base_key_value
255: );
256: --
257: hr_utility.set_location(l_proc, 10);
258: pay_rfi_shd.g_api_dml := true; -- Set the api dml status
259: --
260: -- Update the specified datetrack row setting the effective
261: -- end date to the specified new effective end date.
262: --

Line 270: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status

266: where t.report_format_item_id = p_base_key_value
267: and p_effective_date
268: between t.effective_start_date and t.effective_end_date;
269: --
270: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
271: p_object_version_number := l_object_version_number;
272: hr_utility.set_location(' Leaving:'||l_proc, 15);
273: --
274: Exception

Line 276: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status

272: hr_utility.set_location(' Leaving:'||l_proc, 15);
273: --
274: Exception
275: When Others Then
276: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
277: Raise;
278: --
279: End upd_effective_end_date;
280: --

Line 355: Fetch C_Sel1 Into pay_rfi_shd.g_old_rec;

351: --
352: -- We must select and lock the current row.
353: --
354: Open C_Sel1;
355: Fetch C_Sel1 Into pay_rfi_shd.g_old_rec;
356: If C_Sel1%notfound then
357: Close C_Sel1;
358: --
359: -- The primary key is invalid therefore we must error

Line 366: <> pay_rfi_shd.g_old_rec.object_version_number) Then

362: fnd_message.raise_error;
363: End If;
364: Close C_Sel1;
365: If (p_object_version_number
366: <> pay_rfi_shd.g_old_rec.object_version_number) Then
367: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
368: fnd_message.raise_error;
369: End If;
370:

Line 371: pay_rfi_shd.g_old_rec.report_format_mapping_id

367: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
368: fnd_message.raise_error;
369: End If;
370:
371: pay_rfi_shd.g_old_rec.report_format_mapping_id
372: := pay_rfm_shd.get_report_format_mapping_id
373: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
374: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
375: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );

Line 373: ( p_report_type => pay_rfi_shd.g_old_rec.report_type

369: End If;
370:
371: pay_rfi_shd.g_old_rec.report_format_mapping_id
372: := pay_rfm_shd.get_report_format_mapping_id
373: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
374: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
375: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
376:
377:

Line 374: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier

370:
371: pay_rfi_shd.g_old_rec.report_format_mapping_id
372: := pay_rfm_shd.get_report_format_mapping_id
373: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
374: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
375: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
376:
377:
378: --

Line 375: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );

371: pay_rfi_shd.g_old_rec.report_format_mapping_id
372: := pay_rfm_shd.get_report_format_mapping_id
373: ( p_report_type => pay_rfi_shd.g_old_rec.report_type
374: ,p_report_qualifier => pay_rfi_shd.g_old_rec.report_qualifier
375: ,p_report_category => pay_rfi_shd.g_old_rec.report_category );
376:
377:
378: --
379: --

Line 391: ,p_parent_key_value1 => pay_rfi_shd.g_old_rec.report_format_mapping_id

387: ,p_base_key_column => 'report_format_item_id'
388: ,p_base_key_value => p_report_format_item_id
389: ,p_parent_table_name1 => 'pay_report_format_mappings_f'
390: ,p_parent_key_column1 => 'report_format_mapping_id'
391: ,p_parent_key_value1 => pay_rfi_shd.g_old_rec.report_format_mapping_id
392: ,p_enforce_foreign_locking => true
393: ,p_validation_start_date => l_validation_start_date
394: ,p_validation_end_date => l_validation_end_date
395: );

Line 538: end pay_rfi_shd;

534: return l_report_format_item_id;
535: --
536: End get_report_format_item_id;
537: --
538: end pay_rfi_shd;