1 PACKAGE per_qh_summary_update AUTHID CURRENT_USER as
2 /* $Header: peqhsumi.pkh 115.4 2003/05/14 12:48:09 adhunter noship $ */
3
4 procedure update_summary_data
5 (p_effective_date in date
6 ,p_person_id in per_all_people_f.person_id%type
7 ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
8 ,p_chk1_item_code in per_checklist_items.item_code%type
9 ,p_chk1_date_due in per_checklist_items.date_due%type
10 ,p_chk1_date_done in per_checklist_items.date_done%type
11 ,p_chk1_status in per_checklist_items.status%type
12 ,p_chk1_notes in per_checklist_items.notes%type
13 ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
14 ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
15 ,p_chk2_item_code in per_checklist_items.item_code%type
16 ,p_chk2_date_due in per_checklist_items.date_due%type
17 ,p_chk2_date_done in per_checklist_items.date_done%type
18 ,p_chk2_status in per_checklist_items.status%type
19 ,p_chk2_notes in per_checklist_items.notes%type
20 ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
21 ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
22 ,p_chk3_item_code in per_checklist_items.item_code%type
23 ,p_chk3_date_due in per_checklist_items.date_due%type
24 ,p_chk3_date_done in per_checklist_items.date_done%type
25 ,p_chk3_status in per_checklist_items.status%type
26 ,p_chk3_notes in per_checklist_items.notes%type
27 ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
28 ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
29 ,p_chk4_item_code in per_checklist_items.item_code%type
30 ,p_chk4_date_due in per_checklist_items.date_due%type
31 ,p_chk4_date_done in per_checklist_items.date_done%type
32 ,p_chk4_status in per_checklist_items.status%type
33 ,p_chk4_notes in per_checklist_items.notes%type
34 ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
35 ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
36 ,p_chk5_item_code in per_checklist_items.item_code%type
37 ,p_chk5_date_due in per_checklist_items.date_due%type
38 ,p_chk5_date_done in per_checklist_items.date_done%type
39 ,p_chk5_status in per_checklist_items.status%type
40 ,p_chk5_notes in per_checklist_items.notes%type
41 ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
42 ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
43 ,p_chk6_item_code in per_checklist_items.item_code%type
44 ,p_chk6_date_due in per_checklist_items.date_due%type
45 ,p_chk6_date_done in per_checklist_items.date_done%type
46 ,p_chk6_status in per_checklist_items.status%type
47 ,p_chk6_notes in per_checklist_items.notes%type
48 ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
49 ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
50 ,p_chk7_item_code in per_checklist_items.item_code%type
51 ,p_chk7_date_due in per_checklist_items.date_due%type
52 ,p_chk7_date_done in per_checklist_items.date_done%type
53 ,p_chk7_status in per_checklist_items.status%type
54 ,p_chk7_notes in per_checklist_items.notes%type
55 ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
56 ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
57 ,p_chk8_item_code in per_checklist_items.item_code%type
58 ,p_chk8_date_due in per_checklist_items.date_due%type
59 ,p_chk8_date_done in per_checklist_items.date_done%type
60 ,p_chk8_status in per_checklist_items.status%type
61 ,p_chk8_notes in per_checklist_items.notes%type
62 ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
63 ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
64 ,p_chk9_item_code in per_checklist_items.item_code%type
65 ,p_chk9_date_due in per_checklist_items.date_due%type
66 ,p_chk9_date_done in per_checklist_items.date_done%type
67 ,p_chk9_status in per_checklist_items.status%type
68 ,p_chk9_notes in per_checklist_items.notes%type
69 ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
70 ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
71 ,p_chk10_item_code in per_checklist_items.item_code%type
72 ,p_chk10_date_due in per_checklist_items.date_due%type
73 ,p_chk10_date_done in per_checklist_items.date_done%type
74 ,p_chk10_status in per_checklist_items.status%type
75 ,p_chk10_notes in per_checklist_items.notes%type
76 ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
77 );
78 --
79 procedure lock_summary_data
80 (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
81 ,p_chk1_object_version_number per_checklist_items.object_version_number%type
82 ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
83 ,p_chk2_object_version_number per_checklist_items.object_version_number%type
84 ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
85 ,p_chk3_object_version_number per_checklist_items.object_version_number%type
86 ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
87 ,p_chk4_object_version_number per_checklist_items.object_version_number%type
88 ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
89 ,p_chk5_object_version_number per_checklist_items.object_version_number%type
90 ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
91 ,p_chk6_object_version_number per_checklist_items.object_version_number%type
92 ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
93 ,p_chk7_object_version_number per_checklist_items.object_version_number%type
94 ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
95 ,p_chk8_object_version_number per_checklist_items.object_version_number%type
96 ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
97 ,p_chk9_object_version_number per_checklist_items.object_version_number%type
98 ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
99 ,p_chk10_object_version_number per_checklist_items.object_version_number%type
100 );
101 --
102 end;
[Home] [Help]