7: --
8: procedure update_summary_data
9: (p_effective_date in date
10: ,p_person_id in per_all_people_f.person_id%type
11: ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
8: procedure update_summary_data
9: (p_effective_date in date
10: ,p_person_id in per_all_people_f.person_id%type
11: ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
9: (p_effective_date in date
10: ,p_person_id in per_all_people_f.person_id%type
11: ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
10: ,p_person_id in per_all_people_f.person_id%type
11: ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
11: ,p_chk1_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
12: ,p_chk1_item_code in per_checklist_items.item_code%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
13: ,p_chk1_date_due in per_checklist_items.date_due%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
14: ,p_chk1_date_done in per_checklist_items.date_done%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
15: ,p_chk1_status in per_checklist_items.status%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
16: ,p_chk1_notes in per_checklist_items.notes%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
17: ,p_chk1_object_version_number in out nocopy per_checklist_items.object_version_number%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
18: ,p_chk2_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
19: ,p_chk2_item_code in per_checklist_items.item_code%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
20: ,p_chk2_date_due in per_checklist_items.date_due%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
21: ,p_chk2_date_done in per_checklist_items.date_done%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
22: ,p_chk2_status in per_checklist_items.status%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
23: ,p_chk2_notes in per_checklist_items.notes%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
24: ,p_chk2_object_version_number in out nocopy per_checklist_items.object_version_number%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
25: ,p_chk3_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
26: ,p_chk3_item_code in per_checklist_items.item_code%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
27: ,p_chk3_date_due in per_checklist_items.date_due%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
28: ,p_chk3_date_done in per_checklist_items.date_done%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
29: ,p_chk3_status in per_checklist_items.status%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
30: ,p_chk3_notes in per_checklist_items.notes%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
31: ,p_chk3_object_version_number in out nocopy per_checklist_items.object_version_number%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
32: ,p_chk4_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
33: ,p_chk4_item_code in per_checklist_items.item_code%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
34: ,p_chk4_date_due in per_checklist_items.date_due%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
35: ,p_chk4_date_done in per_checklist_items.date_done%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
36: ,p_chk4_status in per_checklist_items.status%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
37: ,p_chk4_notes in per_checklist_items.notes%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
38: ,p_chk4_object_version_number in out nocopy per_checklist_items.object_version_number%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
39: ,p_chk5_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
40: ,p_chk5_item_code in per_checklist_items.item_code%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
41: ,p_chk5_date_due in per_checklist_items.date_due%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
42: ,p_chk5_date_done in per_checklist_items.date_done%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
43: ,p_chk5_status in per_checklist_items.status%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
44: ,p_chk5_notes in per_checklist_items.notes%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
45: ,p_chk5_object_version_number in out nocopy per_checklist_items.object_version_number%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
46: ,p_chk6_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
47: ,p_chk6_item_code in per_checklist_items.item_code%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
48: ,p_chk6_date_due in per_checklist_items.date_due%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
49: ,p_chk6_date_done in per_checklist_items.date_done%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
50: ,p_chk6_status in per_checklist_items.status%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
51: ,p_chk6_notes in per_checklist_items.notes%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
52: ,p_chk6_object_version_number in out nocopy per_checklist_items.object_version_number%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
53: ,p_chk7_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
54: ,p_chk7_item_code in per_checklist_items.item_code%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
55: ,p_chk7_date_due in per_checklist_items.date_due%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
56: ,p_chk7_date_done in per_checklist_items.date_done%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
57: ,p_chk7_status in per_checklist_items.status%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
58: ,p_chk7_notes in per_checklist_items.notes%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
59: ,p_chk7_object_version_number in out nocopy per_checklist_items.object_version_number%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
60: ,p_chk8_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
61: ,p_chk8_item_code in per_checklist_items.item_code%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
62: ,p_chk8_date_due in per_checklist_items.date_due%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
63: ,p_chk8_date_done in per_checklist_items.date_done%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
64: ,p_chk8_status in per_checklist_items.status%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
65: ,p_chk8_notes in per_checklist_items.notes%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
66: ,p_chk8_object_version_number in out nocopy per_checklist_items.object_version_number%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
67: ,p_chk9_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
68: ,p_chk9_item_code in per_checklist_items.item_code%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
69: ,p_chk9_date_due in per_checklist_items.date_due%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
70: ,p_chk9_date_done in per_checklist_items.date_done%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
71: ,p_chk9_status in per_checklist_items.status%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
72: ,p_chk9_notes in per_checklist_items.notes%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
73: ,p_chk9_object_version_number in out nocopy per_checklist_items.object_version_number%type
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
74: ,p_chk10_checklist_item_id in out nocopy per_checklist_items.checklist_item_id%type
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
82: --
75: ,p_chk10_item_code in per_checklist_items.item_code%type
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
82: --
83: l_checklist_item_id per_checklist_items.checklist_item_id%type;
76: ,p_chk10_date_due in per_checklist_items.date_due%type
77: ,p_chk10_date_done in per_checklist_items.date_done%type
78: ,p_chk10_status in per_checklist_items.status%type
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
82: --
83: l_checklist_item_id per_checklist_items.checklist_item_id%type;
84: l_chk_object_version_number per_checklist_items.object_version_number%type;
79: ,p_chk10_notes in per_checklist_items.notes%type
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
82: --
83: l_checklist_item_id per_checklist_items.checklist_item_id%type;
84: l_chk_object_version_number per_checklist_items.object_version_number%type;
85: l_proc varchar2(72) := g_package||'update_summary_data';
86: --
87: begin
80: ,p_chk10_object_version_number in out nocopy per_checklist_items.object_version_number%type
81: ) is
82: --
83: l_checklist_item_id per_checklist_items.checklist_item_id%type;
84: l_chk_object_version_number per_checklist_items.object_version_number%type;
85: l_proc varchar2(72) := g_package||'update_summary_data';
86: --
87: begin
88: --
133: <> nvl(p_chk1_notes,hr_api.g_varchar2))) then
134: --
135: hr_utility.set_location(l_proc, 30);
136: --
137: per_checklist_items_api.cre_or_upd_checklist_items
138: (p_checklist_item_id => l_checklist_item_id
139: ,p_effective_date => p_effective_date
140: ,p_object_version_number => l_chk_object_version_number
141: ,p_person_id => p_person_id
171: <> nvl(p_chk2_notes,hr_api.g_varchar2))) then
172: --
173: hr_utility.set_location(l_proc, 50);
174: --
175: per_checklist_items_api.cre_or_upd_checklist_items
176: (p_checklist_item_id => l_checklist_item_id
177: ,p_effective_date => p_effective_date
178: ,p_object_version_number => l_chk_object_version_number
179: ,p_person_id => p_person_id
209: <> nvl(p_chk3_notes,hr_api.g_varchar2))) then
210: --
211: hr_utility.set_location(l_proc, 70);
212: --
213: per_checklist_items_api.cre_or_upd_checklist_items
214: (p_checklist_item_id => l_checklist_item_id
215: ,p_effective_date => p_effective_date
216: ,p_object_version_number => l_chk_object_version_number
217: ,p_person_id => p_person_id
247: <> nvl(p_chk4_notes,hr_api.g_varchar2))) then
248: --
249: hr_utility.set_location(l_proc, 90);
250: --
251: per_checklist_items_api.cre_or_upd_checklist_items
252: (p_checklist_item_id => l_checklist_item_id
253: ,p_effective_date => p_effective_date
254: ,p_object_version_number => l_chk_object_version_number
255: ,p_person_id => p_person_id
285: <> nvl(p_chk5_notes,hr_api.g_varchar2))) then
286: --
287: hr_utility.set_location(l_proc, 110);
288: --
289: per_checklist_items_api.cre_or_upd_checklist_items
290: (p_checklist_item_id => l_checklist_item_id
291: ,p_effective_date => p_effective_date
292: ,p_object_version_number => l_chk_object_version_number
293: ,p_person_id => p_person_id
323: <> nvl(p_chk6_notes,hr_api.g_varchar2))) then
324: --
325: hr_utility.set_location(l_proc, 130);
326: --
327: per_checklist_items_api.cre_or_upd_checklist_items
328: (p_checklist_item_id => l_checklist_item_id
329: ,p_effective_date => p_effective_date
330: ,p_object_version_number => l_chk_object_version_number
331: ,p_person_id => p_person_id
361: <> nvl(p_chk7_notes,hr_api.g_varchar2))) then
362: --
363: hr_utility.set_location(l_proc, 150);
364: --
365: per_checklist_items_api.cre_or_upd_checklist_items
366: (p_checklist_item_id => l_checklist_item_id
367: ,p_effective_date => p_effective_date
368: ,p_object_version_number => l_chk_object_version_number
369: ,p_person_id => p_person_id
399: <> nvl(p_chk8_notes,hr_api.g_varchar2))) then
400: --
401: hr_utility.set_location(l_proc, 170);
402: --
403: per_checklist_items_api.cre_or_upd_checklist_items
404: (p_checklist_item_id => l_checklist_item_id
405: ,p_effective_date => p_effective_date
406: ,p_object_version_number => l_chk_object_version_number
407: ,p_person_id => p_person_id
437: <> nvl(p_chk9_notes,hr_api.g_varchar2))) then
438: --
439: hr_utility.set_location(l_proc, 190);
440: --
441: per_checklist_items_api.cre_or_upd_checklist_items
442: (p_checklist_item_id => l_checklist_item_id
443: ,p_effective_date => p_effective_date
444: ,p_object_version_number => l_chk_object_version_number
445: ,p_person_id => p_person_id
475: <> nvl(p_chk10_notes,hr_api.g_varchar2))) then
476: --
477: hr_utility.set_location(l_proc, 210);
478: --
479: per_checklist_items_api.cre_or_upd_checklist_items
480: (p_checklist_item_id => l_checklist_item_id
481: ,p_effective_date => p_effective_date
482: ,p_object_version_number => l_chk_object_version_number
483: ,p_person_id => p_person_id
495: --
496: end update_summary_data;
497: --
498: procedure lock_summary_data
499: (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
496: end update_summary_data;
497: --
498: procedure lock_summary_data
499: (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
497: --
498: procedure lock_summary_data
499: (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
498: procedure lock_summary_data
499: (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
499: (p_chk1_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
500: ,p_chk1_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
501: ,p_chk2_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
502: ,p_chk2_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
503: ,p_chk3_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
504: ,p_chk3_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
505: ,p_chk4_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
506: ,p_chk4_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
507: ,p_chk5_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
508: ,p_chk5_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
509: ,p_chk6_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
510: ,p_chk6_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
518: ,p_chk10_object_version_number per_checklist_items.object_version_number%type
511: ,p_chk7_checklist_item_id per_checklist_items.checklist_item_id%type
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
518: ,p_chk10_object_version_number per_checklist_items.object_version_number%type
519: ) is
512: ,p_chk7_object_version_number per_checklist_items.object_version_number%type
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
518: ,p_chk10_object_version_number per_checklist_items.object_version_number%type
519: ) is
520: l_proc varchar2(72) := g_package||'lock_summary_data';
513: ,p_chk8_checklist_item_id per_checklist_items.checklist_item_id%type
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
518: ,p_chk10_object_version_number per_checklist_items.object_version_number%type
519: ) is
520: l_proc varchar2(72) := g_package||'lock_summary_data';
521: begin
514: ,p_chk8_object_version_number per_checklist_items.object_version_number%type
515: ,p_chk9_checklist_item_id per_checklist_items.checklist_item_id%type
516: ,p_chk9_object_version_number per_checklist_items.object_version_number%type
517: ,p_chk10_checklist_item_id per_checklist_items.checklist_item_id%type
518: ,p_chk10_object_version_number per_checklist_items.object_version_number%type
519: ) is
520: l_proc varchar2(72) := g_package||'lock_summary_data';
521: begin
522: --