APPS.PQH_DOC_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 116: When hr_api.check_integrity_violated Then

112: End If;
113: --
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));

Line 120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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
124: pqh_doc_shd.constraint_error

Line 121: When hr_api.unique_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
124: pqh_doc_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 125: (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;
129: End dt_update_dml;

Line 242: If (p_datetrack_mode <> hr_api.g_correction) then

238: l_dummy_version_number number;
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
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

Line 255: If (p_datetrack_mode = hr_api.g_update_override) then

251: ,p_validation_end_date => p_validation_end_date
252: ,p_object_version_number => l_dummy_version_number
253: );
254: --
255: If (p_datetrack_mode = hr_api.g_update_override) then
256: --
257: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
258: -- delete any future rows
259: --

Line 455: when hr_api.cannot_find_prog_unit then

451: );
452: --
453: exception
454: --
455: when hr_api.cannot_find_prog_unit then
456: --
457: hr_api.cannot_find_prog_unit_error
458: (p_module_name => 'PQH_DOCUMENTS_F'
459: ,p_hook_type => 'AU');

Line 457: hr_api.cannot_find_prog_unit_error

453: exception
454: --
455: when hr_api.cannot_find_prog_unit then
456: --
457: hr_api.cannot_find_prog_unit_error
458: (p_module_name => 'PQH_DOCUMENTS_F'
459: ,p_hook_type => 'AU');
460: --
461: end;

Line 520: If (p_rec.short_name = hr_api.g_varchar2) then

516: -- p_rec plsql record structure
517: -- to see if a system default is being used. If a system default
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

Line 524: If (p_rec.document_name = hr_api.g_varchar2) then

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;
527: End If;
528: If (p_rec.file_id = hr_api.g_number) then

Line 528: If (p_rec.file_id = hr_api.g_number) then

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;
531: End If;
532: If (p_rec.enable_flag = hr_api.g_varchar2) then

Line 532: If (p_rec.enable_flag = hr_api.g_varchar2) then

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;
535: End If;
536: If (p_rec.last_update_by = hr_api.g_number) then

Line 536: If (p_rec.last_update_by = hr_api.g_number) then

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;
539: End If;
540: If (p_rec.formula_id = hr_api.g_number) then

Line 540: If (p_rec.formula_id = hr_api.g_number) then

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;
543: End If;
544: If (p_rec.document_category = hr_api.g_varchar2) then

Line 544: If (p_rec.document_category = hr_api.g_varchar2) then

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;
547: End If;
548: /* Added for XDO changes */

Line 549: If (p_rec.lob_code = 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 :=
551: pqh_doc_shd.g_old_rec.lob_code;
552: End If;
553: If (p_rec.language = hr_api.g_varchar2) then

Line 553: If (p_rec.language = hr_api.g_varchar2) then

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;
556: End If;
557: If (p_rec.territory = hr_api.g_varchar2) then

Line 557: If (p_rec.territory = hr_api.g_varchar2) then

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;
560: End If;
561: --

Line 656: ,p_short_name in varchar2 default hr_api.g_varchar2

652: (p_effective_date in date
653: ,p_datetrack_mode in varchar2
654: ,p_document_id in number
655: ,p_object_version_number in out NOCOPY number
656: ,p_short_name in varchar2 default hr_api.g_varchar2
657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number

Line 657: ,p_document_name in varchar2 default hr_api.g_varchar2

653: ,p_datetrack_mode in varchar2
654: ,p_document_id in number
655: ,p_object_version_number in out NOCOPY number
656: ,p_short_name in varchar2 default hr_api.g_varchar2
657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number

Line 658: ,p_file_id in number default hr_api.g_number

654: ,p_document_id in number
655: ,p_object_version_number in out NOCOPY number
656: ,p_short_name in varchar2 default hr_api.g_varchar2
657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number
662: ,p_document_category in varchar2 default hr_api.g_varchar2

Line 659: ,p_enable_flag in varchar2 default hr_api.g_varchar2

655: ,p_object_version_number in out NOCOPY number
656: ,p_short_name in varchar2 default hr_api.g_varchar2
657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number
662: ,p_document_category in varchar2 default hr_api.g_varchar2
663: ,p_effective_start_date out NOCOPY date

Line 660: ,p_formula_id in number default hr_api.g_number

656: ,p_short_name in varchar2 default hr_api.g_varchar2
657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number
662: ,p_document_category in varchar2 default hr_api.g_varchar2
663: ,p_effective_start_date out NOCOPY date
664: ,p_effective_end_date out NOCOPY date

Line 661: ,p_last_update_by in number default hr_api.g_number

657: ,p_document_name in varchar2 default hr_api.g_varchar2
658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number
662: ,p_document_category in varchar2 default hr_api.g_varchar2
663: ,p_effective_start_date out NOCOPY date
664: ,p_effective_end_date out NOCOPY date
665: /* Added for XDO changes */

Line 662: ,p_document_category in varchar2 default hr_api.g_varchar2

658: ,p_file_id in number default hr_api.g_number
659: ,p_enable_flag in varchar2 default hr_api.g_varchar2
660: ,p_formula_id in number default hr_api.g_number
661: ,p_last_update_by in number default hr_api.g_number
662: ,p_document_category in varchar2 default hr_api.g_varchar2
663: ,p_effective_start_date out NOCOPY date
664: ,p_effective_end_date out NOCOPY date
665: /* Added for XDO changes */
666: ,p_lob_code in varchar2 default hr_api.g_varchar2

Line 666: ,p_lob_code in varchar2 default hr_api.g_varchar2

662: ,p_document_category in varchar2 default hr_api.g_varchar2
663: ,p_effective_start_date out NOCOPY date
664: ,p_effective_end_date out NOCOPY date
665: /* Added for XDO changes */
666: ,p_lob_code in varchar2 default hr_api.g_varchar2
667: ,p_language in varchar2 default hr_api.g_varchar2
668: ,p_territory in varchar2 default hr_api.g_varchar2
669: ) is
670: --

Line 667: ,p_language in varchar2 default hr_api.g_varchar2

663: ,p_effective_start_date out NOCOPY date
664: ,p_effective_end_date out NOCOPY date
665: /* Added for XDO changes */
666: ,p_lob_code in varchar2 default hr_api.g_varchar2
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;

Line 668: ,p_territory in varchar2 default hr_api.g_varchar2

664: ,p_effective_end_date out NOCOPY date
665: /* Added for XDO changes */
666: ,p_lob_code in varchar2 default hr_api.g_varchar2
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';