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_DOC_DEL dependencies on PQH_DOC_SHD

Line 54: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: pqh_doc_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pqh_documents_f
72: where document_id = p_rec.document_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: pqh_doc_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

82: delete from pqh_documents_f
83: where document_id = p_rec.document_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := pqh_doc_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := pqh_doc_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: pqh_doc_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: pqh_doc_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.document_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in pqh_doc_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in pqh_doc_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 322: => pqh_doc_shd.g_old_rec.effective_start_date

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => pqh_doc_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqh_doc_shd.g_old_rec.effective_end_date
325: ,p_short_name_o
326: => pqh_doc_shd.g_old_rec.short_name

Line 324: => pqh_doc_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => pqh_doc_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqh_doc_shd.g_old_rec.effective_end_date
325: ,p_short_name_o
326: => pqh_doc_shd.g_old_rec.short_name
327: ,p_document_name_o
328: => pqh_doc_shd.g_old_rec.document_name

Line 326: => pqh_doc_shd.g_old_rec.short_name

322: => pqh_doc_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => pqh_doc_shd.g_old_rec.effective_end_date
325: ,p_short_name_o
326: => pqh_doc_shd.g_old_rec.short_name
327: ,p_document_name_o
328: => pqh_doc_shd.g_old_rec.document_name
329: ,p_file_id_o
330: => pqh_doc_shd.g_old_rec.file_id

Line 328: => pqh_doc_shd.g_old_rec.document_name

324: => pqh_doc_shd.g_old_rec.effective_end_date
325: ,p_short_name_o
326: => pqh_doc_shd.g_old_rec.short_name
327: ,p_document_name_o
328: => pqh_doc_shd.g_old_rec.document_name
329: ,p_file_id_o
330: => pqh_doc_shd.g_old_rec.file_id
331: ,p_enable_flag_o
332: => pqh_doc_shd.g_old_rec.enable_flag

Line 330: => pqh_doc_shd.g_old_rec.file_id

326: => pqh_doc_shd.g_old_rec.short_name
327: ,p_document_name_o
328: => pqh_doc_shd.g_old_rec.document_name
329: ,p_file_id_o
330: => pqh_doc_shd.g_old_rec.file_id
331: ,p_enable_flag_o
332: => pqh_doc_shd.g_old_rec.enable_flag
333: ,p_last_update_by_o
334: => pqh_doc_shd.g_old_rec.last_update_by

Line 332: => pqh_doc_shd.g_old_rec.enable_flag

328: => pqh_doc_shd.g_old_rec.document_name
329: ,p_file_id_o
330: => pqh_doc_shd.g_old_rec.file_id
331: ,p_enable_flag_o
332: => pqh_doc_shd.g_old_rec.enable_flag
333: ,p_last_update_by_o
334: => pqh_doc_shd.g_old_rec.last_update_by
335: ,p_object_version_number_o
336: => pqh_doc_shd.g_old_rec.object_version_number

Line 334: => pqh_doc_shd.g_old_rec.last_update_by

330: => pqh_doc_shd.g_old_rec.file_id
331: ,p_enable_flag_o
332: => pqh_doc_shd.g_old_rec.enable_flag
333: ,p_last_update_by_o
334: => pqh_doc_shd.g_old_rec.last_update_by
335: ,p_object_version_number_o
336: => pqh_doc_shd.g_old_rec.object_version_number
337: ,p_formula_id_o
338: => pqh_doc_shd.g_old_rec.formula_id

Line 336: => pqh_doc_shd.g_old_rec.object_version_number

332: => pqh_doc_shd.g_old_rec.enable_flag
333: ,p_last_update_by_o
334: => pqh_doc_shd.g_old_rec.last_update_by
335: ,p_object_version_number_o
336: => pqh_doc_shd.g_old_rec.object_version_number
337: ,p_formula_id_o
338: => pqh_doc_shd.g_old_rec.formula_id
339: , p_document_category_o
340: => pqh_doc_shd.g_old_rec.document_category

Line 338: => pqh_doc_shd.g_old_rec.formula_id

334: => pqh_doc_shd.g_old_rec.last_update_by
335: ,p_object_version_number_o
336: => pqh_doc_shd.g_old_rec.object_version_number
337: ,p_formula_id_o
338: => pqh_doc_shd.g_old_rec.formula_id
339: , p_document_category_o
340: => pqh_doc_shd.g_old_rec.document_category
341: /* Added for XDO Changes */
342: ,p_lob_code_o

Line 340: => pqh_doc_shd.g_old_rec.document_category

336: => pqh_doc_shd.g_old_rec.object_version_number
337: ,p_formula_id_o
338: => pqh_doc_shd.g_old_rec.formula_id
339: , p_document_category_o
340: => pqh_doc_shd.g_old_rec.document_category
341: /* Added for XDO Changes */
342: ,p_lob_code_o
343: => pqh_doc_shd.g_old_rec.lob_code
344: ,p_language_o

Line 343: => pqh_doc_shd.g_old_rec.lob_code

339: , p_document_category_o
340: => pqh_doc_shd.g_old_rec.document_category
341: /* Added for XDO Changes */
342: ,p_lob_code_o
343: => pqh_doc_shd.g_old_rec.lob_code
344: ,p_language_o
345: => pqh_doc_shd.g_old_rec.language
346: ,p_territory_o
347: => pqh_doc_shd.g_old_rec.territory

Line 345: => pqh_doc_shd.g_old_rec.language

341: /* Added for XDO Changes */
342: ,p_lob_code_o
343: => pqh_doc_shd.g_old_rec.lob_code
344: ,p_language_o
345: => pqh_doc_shd.g_old_rec.language
346: ,p_territory_o
347: => pqh_doc_shd.g_old_rec.territory
348: );
349: --

Line 347: => pqh_doc_shd.g_old_rec.territory

343: => pqh_doc_shd.g_old_rec.lob_code
344: ,p_language_o
345: => pqh_doc_shd.g_old_rec.language
346: ,p_territory_o
347: => pqh_doc_shd.g_old_rec.territory
348: );
349: --
350: exception
351: --

Line 369: ,p_rec in out NOCOPY pqh_doc_shd.g_rec_type

365: -- ----------------------------------------------------------------------------
366: Procedure del
367: (p_effective_date in date
368: ,p_datetrack_mode in varchar2
369: ,p_rec in out NOCOPY pqh_doc_shd.g_rec_type
370: ) is
371: --
372: l_proc varchar2(72) := g_package||'del';
373: l_validation_start_date date;

Line 385: pqh_doc_shd.lck

381: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
382: --
383: -- We must lock the row which we need to delete.
384: --
385: pqh_doc_shd.lck
386: (p_effective_date => p_effective_date
387: ,p_datetrack_mode => p_datetrack_mode
388: ,p_document_id => p_rec.document_id
389: ,p_object_version_number => p_rec.object_version_number

Line 454: l_rec pqh_doc_shd.g_rec_type;

450: ,p_effective_start_date out NOCOPY date
451: ,p_effective_end_date out NOCOPY date
452: ) is
453: --
454: l_rec pqh_doc_shd.g_rec_type;
455: l_proc varchar2(72) := g_package||'del';
456: --
457: Begin
458: hr_utility.set_location('Entering:'||l_proc, 5);