52: l_language_code fnd_languages.language_code%TYPE;
53:
54: l_proc varchar2(72) := g_package||'copy_template_window';
55: begin
56: hr_utility.set_location('Entering:'|| l_proc, 10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint copy_template_window;
69: --
70: l_language_code := p_language_code;
71: hr_api.validate_language_code(p_language_code => l_language_code);
72: --
73: hr_utility.set_location(l_proc, 20);
74: --
75: --
76: -- Call Before Process User Hook
77: --
90: end;
91: --
92: -- Validation in addition to Row Handlers
93: --
94: hr_utility.set_location('At:'|| l_proc, 15);
95:
96: OPEN cur_api_val;
97: FETCH cur_api_val INTO l_temp;
98: IF (cur_api_val%NOTFOUND AND
108: --
109: --
110: -- Process Logic
111:
112: hr_utility.set_location('At:'|| l_proc, 20);
113:
114: OPEN cur_form_window;
115: FETCH cur_form_window INTO l_form_window_id;
116: CLOSE cur_form_window;
114: OPEN cur_form_window;
115: FETCH cur_form_window INTO l_form_window_id;
116: CLOSE cur_form_window;
117:
118: hr_utility.set_location('At:'|| l_proc, 25);
119:
120: hr_twn_ins.ins( p_form_template_id => p_form_template_id
121: ,p_form_window_id => l_form_window_id
122: ,p_template_window_id => l_template_window_id_to
121: ,p_form_window_id => l_form_window_id
122: ,p_template_window_id => l_template_window_id_to
123: ,p_object_version_number => l_object_version_number);
124:
125: hr_utility.set_location('At:'|| l_proc, 30);
126:
127: hr_window_properties_bsi.copy_window_property(
128: p_effective_date => TRUNC(p_effective_date)
129: ,p_language_code => l_language_code
130: ,p_template_window_id_from => p_template_window_id_from
131: ,p_template_window_id_to => l_template_window_id_to
132: ,p_window_property_id => l_window_property_id);
133:
134: hr_utility.set_location('At:'|| l_proc, 35);
135:
136: FOR cur_rec in cur_tmplt_canvas LOOP
137:
138: hr_template_canvases_api.copy_template_canvas(
145: END LOOP;
146: --
147: -- Call After Process User Hook
148: --
149: hr_utility.set_location('At:'|| l_proc, 40);
150:
151: begin
152: hr_template_windows_api_bk1.copy_template_window_a
153: (p_effective_date => TRUNC(p_effective_date)
174: --
175: p_template_window_id_to := l_template_window_id_to;
176: p_object_version_number := l_object_version_number;
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 70);
179: exception
180: when hr_api.validate_enabled then
181: --
182: -- As the Validate_Enabled exception has been raised
189: -- when validation only mode is being used.)
190: --
191: p_template_window_id_to := null;
192: p_object_version_number := null;
193: hr_utility.set_location(' Leaving:'||l_proc, 80);
194: when others then
195: --
196: -- A validation or unexpected error has occured
197: --
198: p_template_window_id_to := null;
199: p_object_version_number := null;
200:
201: rollback to copy_template_window;
202: hr_utility.set_location(' Leaving:'||l_proc, 90);
203: raise;
204: end copy_template_window;
205: --
206: -- ----------------------------------------------------------------------------
284: l_template_canvas_id number;
285: l_tcn_object_version_number number;
286:
287: begin
288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Issue a savepoint
291: --
292: savepoint create_template_window;
301: --
302: l_language_code := p_language_code;
303: hr_api.validate_language_code(p_language_code => l_language_code);
304: --
305: hr_utility.set_location(l_proc, 20);
306: --
307: --
308: -- Call Before Process User Hook
309: --
359: end;
360: --
361: -- Validation in addition to Row Handlers
362: --
363: hr_utility.set_location('At:'|| l_proc, 15);
364:
365: OPEN cur_api_val;
366: FETCH cur_api_val INTO l_temp;
367: IF (cur_api_val%NOTFOUND AND
377: --
378: --
379: -- Process Logic
380: --
381: hr_utility.set_location('At:'|| l_proc, 20);
382:
383: hr_twn_ins.ins( p_form_template_id => p_form_template_id
384: ,p_form_window_id => p_form_window_id
385: ,p_template_window_id => l_template_window_id
384: ,p_form_window_id => p_form_window_id
385: ,p_template_window_id => l_template_window_id
386: ,p_object_version_number => l_object_version_number);
387:
388: hr_utility.set_location('At:'|| l_proc, 25);
389:
390: hr_window_properties_bsi.copy_window_property(
391: p_effective_date => TRUNC(p_effective_date)
392: ,p_language_code => l_language_code
447: END LOOP;
448: --
449: -- Call After Process User Hook
450: --
451: hr_utility.set_location('At:'|| l_proc, 30);
452:
453: begin
454: hr_template_windows_api_bk2.create_template_window_a
455: (p_effective_date => TRUNC(p_effective_date)
512: --
513: p_template_window_id := l_template_window_id;
514: p_object_version_number := l_object_version_number;
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 70);
517: exception
518: when hr_api.validate_enabled then
519: --
520: -- As the Validate_Enabled exception has been raised
527: -- when validation only mode is being used.)
528: --
529: p_template_window_id := null;
530: p_object_version_number := null;
531: hr_utility.set_location(' Leaving:'||l_proc, 80);
532: when others then
533: --
534: -- A validation or unexpected error has occured
535: --
536: p_template_window_id := null;
537: p_object_version_number := null;
538:
539: rollback to create_template_window;
540: hr_utility.set_location(' Leaving:'||l_proc, 90);
541: raise;
542: end create_template_window;
543: --
544: -- ----------------------------------------------------------------------------
584: AND htw.template_window_id = p_template_window_id);
585:
586: l_proc varchar2(72) := g_package||'delete_template_window';
587: begin
588: hr_utility.set_location('Entering:'|| l_proc, 10);
589: --
590: -- Issue a savepoint
591: --
592: savepoint delete_template_window;
607: end;
608: --
609: -- Validation in addition to Row Handlers
610: --
611: hr_utility.set_location('At:'|| l_proc, 35);
612:
613: OPEN cur_api_val;
614: FETCH cur_api_val INTO l_temp;
615: IF (cur_api_val%NOTFOUND AND
625: --
626: --
627: -- Process Logic
628: --
629: hr_utility.set_location('At:'|| l_proc, 40);
630:
631: hr_twn_shd.lck( p_template_window_id => p_template_window_id
632: ,p_object_version_number => p_object_version_number);
633:
630:
631: hr_twn_shd.lck( p_template_window_id => p_template_window_id
632: ,p_object_version_number => p_object_version_number);
633:
634: hr_utility.set_location('At:'|| l_proc, 45);
635:
636: --
637: -- Delete content canvases
638: --
652: ,p_object_version_number => cur_rec.object_version_number
653: ,p_delete_children_flag => p_delete_children_flag);
654: END LOOP;
655: END IF;
656: hr_utility.set_location('At:'|| l_proc, 50);
657:
658: hr_window_properties_bsi.delete_window_property(
659: p_template_window_id => p_template_window_id);
660:
657:
658: hr_window_properties_bsi.delete_window_property(
659: p_template_window_id => p_template_window_id);
660:
661: hr_utility.set_location('At:'|| l_proc, 55);
662:
663: hr_twn_del.del( p_template_window_id => p_template_window_id
664: ,p_object_version_number => p_object_version_number);
665:
662:
663: hr_twn_del.del( p_template_window_id => p_template_window_id
664: ,p_object_version_number => p_object_version_number);
665:
666: hr_utility.set_location('At:'|| l_proc, 60);
667:
668: --
669: -- Call After Process User Hook
670: --
686: if p_validate then
687: raise hr_api.validate_enabled;
688: end if;
689: --
690: hr_utility.set_location(' Leaving:'||l_proc, 70);
691: exception
692: when hr_api.validate_enabled then
693: --
694: -- As the Validate_Enabled exception has been raised
699: -- Only set output warning arguments
700: -- (Any key or derived arguments must be set to null
701: -- when validation only mode is being used.)
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 80);
704: when others then
705: --
706: -- A validation or unexpected error has occured
707: --
705: --
706: -- A validation or unexpected error has occured
707: --
708: rollback to delete_template_window;
709: hr_utility.set_location(' Leaving:'||l_proc, 90);
710: raise;
711: end delete_template_window;
712: --
713: -- ----------------------------------------------------------------------------
792: l_object_version_number number;
793: l_language_code fnd_languages.language_code%TYPE;
794:
795: begin
796: hr_utility.set_location('Entering:'|| l_proc, 10);
797: --
798: -- Issue a savepoint
799: --
800: savepoint update_template_window;
810: --
811: l_language_code := p_language_code;
812: hr_api.validate_language_code(p_language_code => l_language_code);
813: --
814: hr_utility.set_location(l_proc, 20);
815: --
816: --
817: -- Call Before Process User Hook
818: --
867: end;
868: --
869: -- Validation in addition to Row Handlers
870: --
871: hr_utility.set_location('At:'|| l_proc, 15);
872:
873: OPEN cur_api_val;
874: FETCH cur_api_val INTO l_temp;
875: IF (cur_api_val%NOTFOUND AND
885: --
886: --
887: -- Process Logic
888: --
889: hr_utility.set_location('At:'|| l_proc, 20);
890:
891: hr_twn_shd.lck( p_template_window_id => p_template_window_id
892: ,p_object_version_number => p_object_version_number);
893:
890:
891: hr_twn_shd.lck( p_template_window_id => p_template_window_id
892: ,p_object_version_number => p_object_version_number);
893:
894: hr_utility.set_location('At:'|| l_proc, 25);
895:
896: hr_window_properties_bsi.update_window_property(
897: p_effective_date => TRUNC(p_effective_date)
898: ,p_language_code => l_language_code
933: ,p_information28 => p_information28
934: ,p_information29 => p_information29
935: ,p_information30 => p_information30);
936:
937: hr_utility.set_location('At:'|| l_proc, 30);
938:
939: FOR cur_rec IN cur_tmplt_canvas LOOP
940:
941: hr_template_canvases_api.update_template_canvas(
946: ,p_object_version_number => cur_rec.object_version_number);
947:
948: END LOOP;
949:
950: hr_utility.set_location('At:'|| l_proc, 35);
951:
952: --
953: -- Call After Process User Hook
954: --
1011: -- Set all output arguments
1012: --
1013: p_object_version_number := l_object_version_number;
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: exception
1017: when hr_api.validate_enabled then
1018: --
1019: -- As the Validate_Enabled exception has been raised
1024: -- Only set output warning arguments
1025: -- (Any key or derived arguments must be set to null
1026: -- when validation only mode is being used.)
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 80);
1029: when others then
1030: --
1031: -- A validation or unexpected error has occured
1032: --
1030: --
1031: -- A validation or unexpected error has occured
1032: --
1033: rollback to update_template_window;
1034: hr_utility.set_location(' Leaving:'||l_proc, 90);
1035: raise;
1036: end update_template_window;
1037: --
1038: end hr_template_windows_api;