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

Line 58: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

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

79: ,p_base_key_column => 'document_id'
80: ,p_base_key_value => p_rec.document_id
81: );
82: --
83: pqh_doc_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pqh_documents_f Row
86: --
87: update pqh_documents_f

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

102: where document_id = p_rec.document_id
103: and effective_start_date = p_validation_start_date
104: and effective_end_date = p_validation_end_date;
105: --
106: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
107: --
108: -- Set the effective start and end dates
109: --
110: p_rec.effective_start_date := p_validation_start_date;

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

114: hr_utility.set_location(' Leaving:'||l_proc, 15);
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
119: pqh_doc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated

Line 119: pqh_doc_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
119: pqh_doc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

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

119: pqh_doc_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
124: pqh_doc_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status

Line 124: pqh_doc_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
124: pqh_doc_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;

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

123: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
124: pqh_doc_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: pqh_doc_shd.g_api_dml := false; -- Unset the api dml status
128: Raise;
129: End dt_update_dml;
130: --
131: -- ----------------------------------------------------------------------------

Line 163: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure update_dml
163: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
164: ,p_effective_date in date
165: ,p_datetrack_mode in varchar2
166: ,p_validation_start_date in date
167: ,p_validation_end_date in date

Line 230: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: Procedure dt_pre_update
230: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
231: ,p_effective_date in date
232: ,p_datetrack_mode in varchar2
233: ,p_validation_start_date in date
234: ,p_validation_end_date in date

Line 246: pqh_doc_shd.upd_effective_end_date

242: If (p_datetrack_mode <> hr_api.g_correction) then
243: --
244: -- Update the current effective end date
245: --
246: pqh_doc_shd.upd_effective_end_date
247: (p_effective_date => p_effective_date
248: ,p_base_key_value => p_rec.document_id
249: ,p_new_effective_end_date => (p_validation_start_date - 1)
250: ,p_validation_start_date => p_validation_start_date

Line 315: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure pre_update
315: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date

Line 373: (p_rec in pqh_doc_shd.g_rec_type

369: --
370: -- {End Of Comments}
371: -- ----------------------------------------------------------------------------
372: Procedure post_update
373: (p_rec in pqh_doc_shd.g_rec_type
374: ,p_effective_date in date
375: ,p_datetrack_mode in varchar2
376: ,p_validation_start_date in date
377: ,p_validation_end_date in date

Line 425: => pqh_doc_shd.g_old_rec.effective_start_date

421: => p_rec.language
422: ,p_territory
423: => p_rec.territory
424: ,p_effective_start_date_o
425: => pqh_doc_shd.g_old_rec.effective_start_date
426: ,p_effective_end_date_o
427: => pqh_doc_shd.g_old_rec.effective_end_date
428: ,p_short_name_o
429: => pqh_doc_shd.g_old_rec.short_name

Line 427: => pqh_doc_shd.g_old_rec.effective_end_date

423: => p_rec.territory
424: ,p_effective_start_date_o
425: => pqh_doc_shd.g_old_rec.effective_start_date
426: ,p_effective_end_date_o
427: => pqh_doc_shd.g_old_rec.effective_end_date
428: ,p_short_name_o
429: => pqh_doc_shd.g_old_rec.short_name
430: ,p_document_name_o
431: => pqh_doc_shd.g_old_rec.document_name

Line 429: => pqh_doc_shd.g_old_rec.short_name

425: => pqh_doc_shd.g_old_rec.effective_start_date
426: ,p_effective_end_date_o
427: => pqh_doc_shd.g_old_rec.effective_end_date
428: ,p_short_name_o
429: => pqh_doc_shd.g_old_rec.short_name
430: ,p_document_name_o
431: => pqh_doc_shd.g_old_rec.document_name
432: ,p_file_id_o
433: => pqh_doc_shd.g_old_rec.file_id

Line 431: => pqh_doc_shd.g_old_rec.document_name

427: => pqh_doc_shd.g_old_rec.effective_end_date
428: ,p_short_name_o
429: => pqh_doc_shd.g_old_rec.short_name
430: ,p_document_name_o
431: => pqh_doc_shd.g_old_rec.document_name
432: ,p_file_id_o
433: => pqh_doc_shd.g_old_rec.file_id
434: ,p_enable_flag_o
435: => pqh_doc_shd.g_old_rec.enable_flag

Line 433: => pqh_doc_shd.g_old_rec.file_id

429: => pqh_doc_shd.g_old_rec.short_name
430: ,p_document_name_o
431: => pqh_doc_shd.g_old_rec.document_name
432: ,p_file_id_o
433: => pqh_doc_shd.g_old_rec.file_id
434: ,p_enable_flag_o
435: => pqh_doc_shd.g_old_rec.enable_flag
436: ,p_last_update_by_o
437: => pqh_doc_shd.g_old_rec.last_update_by

Line 435: => pqh_doc_shd.g_old_rec.enable_flag

431: => pqh_doc_shd.g_old_rec.document_name
432: ,p_file_id_o
433: => pqh_doc_shd.g_old_rec.file_id
434: ,p_enable_flag_o
435: => pqh_doc_shd.g_old_rec.enable_flag
436: ,p_last_update_by_o
437: => pqh_doc_shd.g_old_rec.last_update_by
438: ,p_object_version_number_o
439: => pqh_doc_shd.g_old_rec.object_version_number

Line 437: => pqh_doc_shd.g_old_rec.last_update_by

433: => pqh_doc_shd.g_old_rec.file_id
434: ,p_enable_flag_o
435: => pqh_doc_shd.g_old_rec.enable_flag
436: ,p_last_update_by_o
437: => pqh_doc_shd.g_old_rec.last_update_by
438: ,p_object_version_number_o
439: => pqh_doc_shd.g_old_rec.object_version_number
440: ,p_formula_id_o
441: => pqh_doc_shd.g_old_rec.formula_id

Line 439: => pqh_doc_shd.g_old_rec.object_version_number

435: => pqh_doc_shd.g_old_rec.enable_flag
436: ,p_last_update_by_o
437: => pqh_doc_shd.g_old_rec.last_update_by
438: ,p_object_version_number_o
439: => pqh_doc_shd.g_old_rec.object_version_number
440: ,p_formula_id_o
441: => pqh_doc_shd.g_old_rec.formula_id
442: ,p_document_category_o
443: => pqh_doc_shd.g_old_rec.document_category

Line 441: => pqh_doc_shd.g_old_rec.formula_id

437: => pqh_doc_shd.g_old_rec.last_update_by
438: ,p_object_version_number_o
439: => pqh_doc_shd.g_old_rec.object_version_number
440: ,p_formula_id_o
441: => pqh_doc_shd.g_old_rec.formula_id
442: ,p_document_category_o
443: => pqh_doc_shd.g_old_rec.document_category
444: /* Added for XDO Changes. */
445: ,p_lob_code_o

Line 443: => pqh_doc_shd.g_old_rec.document_category

439: => pqh_doc_shd.g_old_rec.object_version_number
440: ,p_formula_id_o
441: => pqh_doc_shd.g_old_rec.formula_id
442: ,p_document_category_o
443: => pqh_doc_shd.g_old_rec.document_category
444: /* Added for XDO Changes. */
445: ,p_lob_code_o
446: => pqh_doc_shd.g_old_rec.lob_code
447: ,p_language_o

Line 446: => pqh_doc_shd.g_old_rec.lob_code

442: ,p_document_category_o
443: => pqh_doc_shd.g_old_rec.document_category
444: /* Added for XDO Changes. */
445: ,p_lob_code_o
446: => pqh_doc_shd.g_old_rec.lob_code
447: ,p_language_o
448: => pqh_doc_shd.g_old_rec.language
449: ,p_territory_o
450: => pqh_doc_shd.g_old_rec.territory

Line 448: => pqh_doc_shd.g_old_rec.language

444: /* Added for XDO Changes. */
445: ,p_lob_code_o
446: => pqh_doc_shd.g_old_rec.lob_code
447: ,p_language_o
448: => pqh_doc_shd.g_old_rec.language
449: ,p_territory_o
450: => pqh_doc_shd.g_old_rec.territory
451: );
452: --

Line 450: => pqh_doc_shd.g_old_rec.territory

446: => pqh_doc_shd.g_old_rec.lob_code
447: ,p_language_o
448: => pqh_doc_shd.g_old_rec.language
449: ,p_territory_o
450: => pqh_doc_shd.g_old_rec.territory
451: );
452: --
453: exception
454: --

Line 510: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type

506: --
507: -- {End Of Comments}
508: -- ----------------------------------------------------------------------------
509: Procedure convert_defs
510: (p_rec in out NOCOPY pqh_doc_shd.g_rec_type
511: ) is
512: --
513: Begin
514: --

Line 522: pqh_doc_shd.g_old_rec.short_name;

518: -- is being used then we must set to the 'current' argument value.
519: --
520: If (p_rec.short_name = hr_api.g_varchar2) then
521: p_rec.short_name :=
522: pqh_doc_shd.g_old_rec.short_name;
523: End If;
524: If (p_rec.document_name = hr_api.g_varchar2) then
525: p_rec.document_name :=
526: pqh_doc_shd.g_old_rec.document_name;

Line 526: pqh_doc_shd.g_old_rec.document_name;

522: pqh_doc_shd.g_old_rec.short_name;
523: End If;
524: If (p_rec.document_name = hr_api.g_varchar2) then
525: p_rec.document_name :=
526: pqh_doc_shd.g_old_rec.document_name;
527: End If;
528: If (p_rec.file_id = hr_api.g_number) then
529: p_rec.file_id :=
530: pqh_doc_shd.g_old_rec.file_id;

Line 530: pqh_doc_shd.g_old_rec.file_id;

526: pqh_doc_shd.g_old_rec.document_name;
527: End If;
528: If (p_rec.file_id = hr_api.g_number) then
529: p_rec.file_id :=
530: pqh_doc_shd.g_old_rec.file_id;
531: End If;
532: If (p_rec.enable_flag = hr_api.g_varchar2) then
533: p_rec.enable_flag :=
534: pqh_doc_shd.g_old_rec.enable_flag;

Line 534: pqh_doc_shd.g_old_rec.enable_flag;

530: pqh_doc_shd.g_old_rec.file_id;
531: End If;
532: If (p_rec.enable_flag = hr_api.g_varchar2) then
533: p_rec.enable_flag :=
534: pqh_doc_shd.g_old_rec.enable_flag;
535: End If;
536: If (p_rec.last_update_by = hr_api.g_number) then
537: p_rec.last_update_by :=
538: pqh_doc_shd.g_old_rec.last_update_by;

Line 538: pqh_doc_shd.g_old_rec.last_update_by;

534: pqh_doc_shd.g_old_rec.enable_flag;
535: End If;
536: If (p_rec.last_update_by = hr_api.g_number) then
537: p_rec.last_update_by :=
538: pqh_doc_shd.g_old_rec.last_update_by;
539: End If;
540: If (p_rec.formula_id = hr_api.g_number) then
541: p_rec.formula_id :=
542: pqh_doc_shd.g_old_rec.formula_id;

Line 542: pqh_doc_shd.g_old_rec.formula_id;

538: pqh_doc_shd.g_old_rec.last_update_by;
539: End If;
540: If (p_rec.formula_id = hr_api.g_number) then
541: p_rec.formula_id :=
542: pqh_doc_shd.g_old_rec.formula_id;
543: End If;
544: If (p_rec.document_category = hr_api.g_varchar2) then
545: p_rec.document_category :=
546: pqh_doc_shd.g_old_rec.document_category;

Line 546: pqh_doc_shd.g_old_rec.document_category;

542: pqh_doc_shd.g_old_rec.formula_id;
543: End If;
544: If (p_rec.document_category = hr_api.g_varchar2) then
545: p_rec.document_category :=
546: pqh_doc_shd.g_old_rec.document_category;
547: End If;
548: /* Added for XDO changes */
549: If (p_rec.lob_code = hr_api.g_varchar2) then
550: p_rec.lob_code :=

Line 551: pqh_doc_shd.g_old_rec.lob_code;

547: End If;
548: /* Added for XDO changes */
549: If (p_rec.lob_code = hr_api.g_varchar2) then
550: p_rec.lob_code :=
551: pqh_doc_shd.g_old_rec.lob_code;
552: End If;
553: If (p_rec.language = hr_api.g_varchar2) then
554: p_rec.language :=
555: pqh_doc_shd.g_old_rec.language;

Line 555: pqh_doc_shd.g_old_rec.language;

551: pqh_doc_shd.g_old_rec.lob_code;
552: End If;
553: If (p_rec.language = hr_api.g_varchar2) then
554: p_rec.language :=
555: pqh_doc_shd.g_old_rec.language;
556: End If;
557: If (p_rec.territory = hr_api.g_varchar2) then
558: p_rec.territory :=
559: pqh_doc_shd.g_old_rec.territory;

Line 559: pqh_doc_shd.g_old_rec.territory;

555: pqh_doc_shd.g_old_rec.language;
556: End If;
557: If (p_rec.territory = hr_api.g_varchar2) then
558: p_rec.territory :=
559: pqh_doc_shd.g_old_rec.territory;
560: End If;
561: --
562: End convert_defs;
563: --

Line 570: ,p_rec in out NOCOPY pqh_doc_shd.g_rec_type

566: -- ----------------------------------------------------------------------------
567: Procedure upd
568: (p_effective_date in date
569: ,p_datetrack_mode in varchar2
570: ,p_rec in out NOCOPY pqh_doc_shd.g_rec_type
571: ) is
572: --
573: l_proc varchar2(72) := g_package||'upd';
574: l_validation_start_date date;

Line 586: pqh_doc_shd.lck

582: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
583: --
584: -- We must lock the row which we need to update.
585: --
586: pqh_doc_shd.lck
587: (p_effective_date => p_effective_date
588: ,p_datetrack_mode => p_datetrack_mode
589: ,p_document_id => p_rec.document_id
590: ,p_object_version_number => p_rec.object_version_number

Line 671: l_rec pqh_doc_shd.g_rec_type;

667: ,p_language in varchar2 default hr_api.g_varchar2
668: ,p_territory in varchar2 default hr_api.g_varchar2
669: ) is
670: --
671: l_rec pqh_doc_shd.g_rec_type;
672: l_proc varchar2(72) := g_package||'upd';
673: --
674: Begin
675: hr_utility.set_location('Entering:'||l_proc, 5);

Line 681: pqh_doc_shd.convert_args

677: -- Call conversion function to turn arguments into the
678: -- l_rec structure.
679: --
680: l_rec :=
681: pqh_doc_shd.convert_args
682: (p_document_id
683: ,null
684: ,null
685: ,p_short_name