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.PQH_DFS_DEL dependencies on PQH_DFS_SHD

Line 45: Procedure delete_dml(p_rec in pqh_dfs_shd.g_rec_type) is

41: -- Internal Row Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in pqh_dfs_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin

Line 64: pqh_dfs_shd.constraint_error

60: --
61: Exception
62: When hr_api.child_integrity_violated then
63: -- Child integrity has been violated
64: pqh_dfs_shd.constraint_error
65: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
66: When Others Then
67: Raise;
68: End delete_dml;

Line 102: Procedure pre_delete(p_rec in pqh_dfs_shd.g_rec_type) is

98: -- Internal Row Handler Use Only.
99: --
100: -- {End Of Comments}
101: -- ----------------------------------------------------------------------------
102: Procedure pre_delete(p_rec in pqh_dfs_shd.g_rec_type) is
103: --
104: l_proc varchar2(72) := g_package||'pre_delete';
105: --
106: Begin

Line 144: Procedure post_delete(p_rec in pqh_dfs_shd.g_rec_type) is

140: -- Internal table Handler Use Only.
141: --
142: -- {End Of Comments}
143: -- ----------------------------------------------------------------------------
144: Procedure post_delete(p_rec in pqh_dfs_shd.g_rec_type) is
145: --
146: l_proc varchar2(72) := g_package||'post_delete';
147: --
148: Begin

Line 159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id

155: --
156: pqh_dfs_rkd.after_delete
157: (
158: p_dflt_fund_src_id =>p_rec.dflt_fund_src_id
159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id
160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id

Line 160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage

156: pqh_dfs_rkd.after_delete
157: (
158: p_dflt_fund_src_id =>p_rec.dflt_fund_src_id
159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id
160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type

Line 161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id

157: (
158: p_dflt_fund_src_id =>p_rec.dflt_fund_src_id
159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id
160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id

Line 162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id

158: p_dflt_fund_src_id =>p_rec.dflt_fund_src_id
159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id
160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number

Line 163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id

159: ,p_dflt_budget_element_id_o =>pqh_dfs_shd.g_old_rec.dflt_budget_element_id
160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number
167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id

Line 164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type

160: ,p_dflt_dist_percentage_o =>pqh_dfs_shd.g_old_rec.dflt_dist_percentage
161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number
167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id
168: );

Line 165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id

161: ,p_project_id_o =>pqh_dfs_shd.g_old_rec.project_id
162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number
167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id
168: );
169: --

Line 166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number

162: ,p_award_id_o =>pqh_dfs_shd.g_old_rec.award_id
163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number
167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id
168: );
169: --
170: exception

Line 167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id

163: ,p_task_id_o =>pqh_dfs_shd.g_old_rec.task_id
164: ,p_expenditure_type_o =>pqh_dfs_shd.g_old_rec.expenditure_type
165: ,p_organization_id_o =>pqh_dfs_shd.g_old_rec.organization_id
166: ,p_object_version_number_o =>pqh_dfs_shd.g_old_rec.object_version_number
167: ,p_cost_allocation_keyflex_id_o =>pqh_dfs_shd.g_old_rec.cost_allocation_keyflex_id
168: );
169: --
170: exception
171: --

Line 191: p_rec in pqh_dfs_shd.g_rec_type

187: -- |---------------------------------< del >----------------------------------|
188: -- ----------------------------------------------------------------------------
189: Procedure del
190: (
191: p_rec in pqh_dfs_shd.g_rec_type
192: ) is
193: --
194: l_proc varchar2(72) := g_package||'del';
195: --

Line 201: pqh_dfs_shd.lck

197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- We must lock the row which we need to delete.
200: --
201: pqh_dfs_shd.lck
202: (
203: p_rec.dflt_fund_src_id,
204: p_rec.object_version_number
205: );

Line 233: l_rec pqh_dfs_shd.g_rec_type;

229: p_dflt_fund_src_id in number,
230: p_object_version_number in number
231: ) is
232: --
233: l_rec pqh_dfs_shd.g_rec_type;
234: l_proc varchar2(72) := g_package||'del';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);