5: */
6:
7: TYPE deliverable_rec_type IS RECORD (
8: deliverable_id okc_deliverables.deliverable_id%TYPE
9: := okc_api.g_miss_num,
10: business_document_type okc_deliverables.business_document_type%TYPE
11: := okc_api.g_miss_char,
12: business_document_id okc_deliverables.business_document_id%TYPE
13: := okc_api.g_miss_num,
7: TYPE deliverable_rec_type IS RECORD (
8: deliverable_id okc_deliverables.deliverable_id%TYPE
9: := okc_api.g_miss_num,
10: business_document_type okc_deliverables.business_document_type%TYPE
11: := okc_api.g_miss_char,
12: business_document_id okc_deliverables.business_document_id%TYPE
13: := okc_api.g_miss_num,
14: business_document_number okc_deliverables.business_document_number%TYPE
15: := okc_api.g_miss_char,
9: := okc_api.g_miss_num,
10: business_document_type okc_deliverables.business_document_type%TYPE
11: := okc_api.g_miss_char,
12: business_document_id okc_deliverables.business_document_id%TYPE
13: := okc_api.g_miss_num,
14: business_document_number okc_deliverables.business_document_number%TYPE
15: := okc_api.g_miss_char,
16: deliverable_type okc_deliverables.deliverable_type%TYPE
17: := okc_api.g_miss_char,
11: := okc_api.g_miss_char,
12: business_document_id okc_deliverables.business_document_id%TYPE
13: := okc_api.g_miss_num,
14: business_document_number okc_deliverables.business_document_number%TYPE
15: := okc_api.g_miss_char,
16: deliverable_type okc_deliverables.deliverable_type%TYPE
17: := okc_api.g_miss_char,
18: responsible_party okc_deliverables.responsible_party%TYPE
19: := okc_api.g_miss_char,
13: := okc_api.g_miss_num,
14: business_document_number okc_deliverables.business_document_number%TYPE
15: := okc_api.g_miss_char,
16: deliverable_type okc_deliverables.deliverable_type%TYPE
17: := okc_api.g_miss_char,
18: responsible_party okc_deliverables.responsible_party%TYPE
19: := okc_api.g_miss_char,
20: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
21: := okc_api.g_miss_num,
15: := okc_api.g_miss_char,
16: deliverable_type okc_deliverables.deliverable_type%TYPE
17: := okc_api.g_miss_char,
18: responsible_party okc_deliverables.responsible_party%TYPE
19: := okc_api.g_miss_char,
20: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
21: := okc_api.g_miss_num,
22: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
23: := okc_api.g_miss_num,
17: := okc_api.g_miss_char,
18: responsible_party okc_deliverables.responsible_party%TYPE
19: := okc_api.g_miss_char,
20: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
21: := okc_api.g_miss_num,
22: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
23: := okc_api.g_miss_num,
24: deliverable_name okc_deliverables.deliverable_name%TYPE
25: := okc_api.g_miss_char,
19: := okc_api.g_miss_char,
20: internal_party_contact_id okc_deliverables.internal_party_contact_id%TYPE
21: := okc_api.g_miss_num,
22: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
23: := okc_api.g_miss_num,
24: deliverable_name okc_deliverables.deliverable_name%TYPE
25: := okc_api.g_miss_char,
26: description okc_deliverables.description%TYPE
27: := okc_api.g_miss_char,
21: := okc_api.g_miss_num,
22: external_party_contact_id okc_deliverables.external_party_contact_id%TYPE
23: := okc_api.g_miss_num,
24: deliverable_name okc_deliverables.deliverable_name%TYPE
25: := okc_api.g_miss_char,
26: description okc_deliverables.description%TYPE
27: := okc_api.g_miss_char,
28: comments okc_deliverables.comments%TYPE
29: := okc_api.g_miss_char,
23: := okc_api.g_miss_num,
24: deliverable_name okc_deliverables.deliverable_name%TYPE
25: := okc_api.g_miss_char,
26: description okc_deliverables.description%TYPE
27: := okc_api.g_miss_char,
28: comments okc_deliverables.comments%TYPE
29: := okc_api.g_miss_char,
30: display_sequence okc_deliverables.display_sequence%TYPE
31: := okc_api.g_miss_num,
25: := okc_api.g_miss_char,
26: description okc_deliverables.description%TYPE
27: := okc_api.g_miss_char,
28: comments okc_deliverables.comments%TYPE
29: := okc_api.g_miss_char,
30: display_sequence okc_deliverables.display_sequence%TYPE
31: := okc_api.g_miss_num,
32: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
33: := okc_api.g_miss_char,
27: := okc_api.g_miss_char,
28: comments okc_deliverables.comments%TYPE
29: := okc_api.g_miss_char,
30: display_sequence okc_deliverables.display_sequence%TYPE
31: := okc_api.g_miss_num,
32: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
33: := okc_api.g_miss_char,
34: actual_due_date okc_deliverables.actual_due_date%TYPE
35: := okc_api.g_miss_date,
29: := okc_api.g_miss_char,
30: display_sequence okc_deliverables.display_sequence%TYPE
31: := okc_api.g_miss_num,
32: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
33: := okc_api.g_miss_char,
34: actual_due_date okc_deliverables.actual_due_date%TYPE
35: := okc_api.g_miss_date,
36: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
37: := okc_api.g_miss_char,
31: := okc_api.g_miss_num,
32: fixed_due_date_yn okc_deliverables.fixed_due_date_yn%TYPE
33: := okc_api.g_miss_char,
34: actual_due_date okc_deliverables.actual_due_date%TYPE
35: := okc_api.g_miss_date,
36: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
37: := okc_api.g_miss_char,
38: recurring_yn okc_deliverables.recurring_yn%TYPE
39: := okc_api.g_miss_char,
33: := okc_api.g_miss_char,
34: actual_due_date okc_deliverables.actual_due_date%TYPE
35: := okc_api.g_miss_date,
36: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
37: := okc_api.g_miss_char,
38: recurring_yn okc_deliverables.recurring_yn%TYPE
39: := okc_api.g_miss_char,
40: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
41: := okc_api.g_miss_num,
35: := okc_api.g_miss_date,
36: print_due_date_msg_name okc_deliverables.print_due_date_msg_name%TYPE
37: := okc_api.g_miss_char,
38: recurring_yn okc_deliverables.recurring_yn%TYPE
39: := okc_api.g_miss_char,
40: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
41: := okc_api.g_miss_num,
42: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
43: := okc_api.g_miss_char,
37: := okc_api.g_miss_char,
38: recurring_yn okc_deliverables.recurring_yn%TYPE
39: := okc_api.g_miss_char,
40: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
41: := okc_api.g_miss_num,
42: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
43: := okc_api.g_miss_char,
44: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
45: := okc_api.g_miss_char,
39: := okc_api.g_miss_char,
40: notify_prior_due_date_value okc_deliverables.notify_prior_due_date_value%TYPE
41: := okc_api.g_miss_num,
42: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
43: := okc_api.g_miss_char,
44: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
45: := okc_api.g_miss_char,
46: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
47: := okc_api.g_miss_char,
41: := okc_api.g_miss_num,
42: notify_prior_due_date_uom okc_deliverables.notify_prior_due_date_uom%TYPE
43: := okc_api.g_miss_char,
44: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
45: := okc_api.g_miss_char,
46: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
47: := okc_api.g_miss_char,
48: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
49: := okc_api.g_miss_char,
43: := okc_api.g_miss_char,
44: notify_prior_due_date_yn okc_deliverables.notify_prior_due_date_yn%TYPE
45: := okc_api.g_miss_char,
46: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
47: := okc_api.g_miss_char,
48: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
49: := okc_api.g_miss_char,
50: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
51: := okc_api.g_miss_char,
45: := okc_api.g_miss_char,
46: notify_completed_yn okc_deliverables.notify_completed_yn%TYPE
47: := okc_api.g_miss_char,
48: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
49: := okc_api.g_miss_char,
50: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
51: := okc_api.g_miss_char,
52: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
53: := okc_api.g_miss_num,
47: := okc_api.g_miss_char,
48: notify_overdue_yn okc_deliverables.notify_overdue_yn%TYPE
49: := okc_api.g_miss_char,
50: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
51: := okc_api.g_miss_char,
52: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
53: := okc_api.g_miss_num,
54: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
55: := okc_api.g_miss_char,
49: := okc_api.g_miss_char,
50: notify_escalation_yn okc_deliverables.notify_escalation_yn%TYPE
51: := okc_api.g_miss_char,
52: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
53: := okc_api.g_miss_num,
54: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
55: := okc_api.g_miss_char,
56: escalation_assignee okc_deliverables.escalation_assignee%TYPE
57: := okc_api.g_miss_num,
51: := okc_api.g_miss_char,
52: notify_escalation_value okc_deliverables.notify_escalation_value%TYPE
53: := okc_api.g_miss_num,
54: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
55: := okc_api.g_miss_char,
56: escalation_assignee okc_deliverables.escalation_assignee%TYPE
57: := okc_api.g_miss_num,
58: amendment_operation okc_deliverables.amendment_operation%TYPE
59: := okc_api.g_miss_char,
53: := okc_api.g_miss_num,
54: notify_escalation_uom okc_deliverables.notify_escalation_uom%TYPE
55: := okc_api.g_miss_char,
56: escalation_assignee okc_deliverables.escalation_assignee%TYPE
57: := okc_api.g_miss_num,
58: amendment_operation okc_deliverables.amendment_operation%TYPE
59: := okc_api.g_miss_char,
60: prior_notification_id okc_deliverables.prior_notification_id%TYPE
61: := okc_api.g_miss_num,
55: := okc_api.g_miss_char,
56: escalation_assignee okc_deliverables.escalation_assignee%TYPE
57: := okc_api.g_miss_num,
58: amendment_operation okc_deliverables.amendment_operation%TYPE
59: := okc_api.g_miss_char,
60: prior_notification_id okc_deliverables.prior_notification_id%TYPE
61: := okc_api.g_miss_num,
62: amendment_notes okc_deliverables.amendment_notes%TYPE
63: := okc_api.g_miss_char,
57: := okc_api.g_miss_num,
58: amendment_operation okc_deliverables.amendment_operation%TYPE
59: := okc_api.g_miss_char,
60: prior_notification_id okc_deliverables.prior_notification_id%TYPE
61: := okc_api.g_miss_num,
62: amendment_notes okc_deliverables.amendment_notes%TYPE
63: := okc_api.g_miss_char,
64: completed_notification_id okc_deliverables.completed_notification_id%TYPE
65: := okc_api.g_miss_num,
59: := okc_api.g_miss_char,
60: prior_notification_id okc_deliverables.prior_notification_id%TYPE
61: := okc_api.g_miss_num,
62: amendment_notes okc_deliverables.amendment_notes%TYPE
63: := okc_api.g_miss_char,
64: completed_notification_id okc_deliverables.completed_notification_id%TYPE
65: := okc_api.g_miss_num,
66: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
67: := okc_api.g_miss_num,
61: := okc_api.g_miss_num,
62: amendment_notes okc_deliverables.amendment_notes%TYPE
63: := okc_api.g_miss_char,
64: completed_notification_id okc_deliverables.completed_notification_id%TYPE
65: := okc_api.g_miss_num,
66: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
67: := okc_api.g_miss_num,
68: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
69: := okc_api.g_miss_num,
63: := okc_api.g_miss_char,
64: completed_notification_id okc_deliverables.completed_notification_id%TYPE
65: := okc_api.g_miss_num,
66: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
67: := okc_api.g_miss_num,
68: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
69: := okc_api.g_miss_num,
70: LANGUAGE okc_deliverables.LANGUAGE%TYPE
71: := okc_api.g_miss_char,
65: := okc_api.g_miss_num,
66: overdue_notification_id okc_deliverables.overdue_notification_id%TYPE
67: := okc_api.g_miss_num,
68: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
69: := okc_api.g_miss_num,
70: LANGUAGE okc_deliverables.LANGUAGE%TYPE
71: := okc_api.g_miss_char,
72: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
73: := okc_api.g_miss_num,
67: := okc_api.g_miss_num,
68: escalation_notification_id okc_deliverables.escalation_notification_id%TYPE
69: := okc_api.g_miss_num,
70: LANGUAGE okc_deliverables.LANGUAGE%TYPE
71: := okc_api.g_miss_char,
72: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
73: := okc_api.g_miss_num,
74: requester_id okc_deliverables.requester_id%TYPE
75: := okc_api.g_miss_num,
69: := okc_api.g_miss_num,
70: LANGUAGE okc_deliverables.LANGUAGE%TYPE
71: := okc_api.g_miss_char,
72: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
73: := okc_api.g_miss_num,
74: requester_id okc_deliverables.requester_id%TYPE
75: := okc_api.g_miss_num,
76: external_party_id okc_deliverables.external_party_id%TYPE
77: := okc_api.g_miss_num,
71: := okc_api.g_miss_char,
72: original_deliverable_id okc_deliverables.original_deliverable_id%TYPE
73: := okc_api.g_miss_num,
74: requester_id okc_deliverables.requester_id%TYPE
75: := okc_api.g_miss_num,
76: external_party_id okc_deliverables.external_party_id%TYPE
77: := okc_api.g_miss_num,
78: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
79: := okc_api.g_miss_num,
73: := okc_api.g_miss_num,
74: requester_id okc_deliverables.requester_id%TYPE
75: := okc_api.g_miss_num,
76: external_party_id okc_deliverables.external_party_id%TYPE
77: := okc_api.g_miss_num,
78: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
79: := okc_api.g_miss_num,
80: business_document_version okc_deliverables.business_document_version%TYPE
81: := okc_api.g_miss_num,
75: := okc_api.g_miss_num,
76: external_party_id okc_deliverables.external_party_id%TYPE
77: := okc_api.g_miss_num,
78: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
79: := okc_api.g_miss_num,
80: business_document_version okc_deliverables.business_document_version%TYPE
81: := okc_api.g_miss_num,
82: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
83: := okc_api.g_miss_num,
77: := okc_api.g_miss_num,
78: recurring_del_parent_id okc_deliverables.recurring_del_parent_id%TYPE
79: := okc_api.g_miss_num,
80: business_document_version okc_deliverables.business_document_version%TYPE
81: := okc_api.g_miss_num,
82: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
83: := okc_api.g_miss_num,
84: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
85: := okc_api.g_miss_char,
79: := okc_api.g_miss_num,
80: business_document_version okc_deliverables.business_document_version%TYPE
81: := okc_api.g_miss_num,
82: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
83: := okc_api.g_miss_num,
84: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
85: := okc_api.g_miss_char,
86: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
87: := okc_api.g_miss_num,
81: := okc_api.g_miss_num,
82: relative_st_date_duration okc_deliverables.relative_st_date_duration%TYPE
83: := okc_api.g_miss_num,
84: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
85: := okc_api.g_miss_char,
86: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
87: := okc_api.g_miss_num,
88: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
89: := okc_api.g_miss_num,
83: := okc_api.g_miss_num,
84: relative_st_date_uom okc_deliverables.relative_st_date_uom%TYPE
85: := okc_api.g_miss_char,
86: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
87: := okc_api.g_miss_num,
88: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
89: := okc_api.g_miss_num,
90: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
91: := okc_api.g_miss_char,
85: := okc_api.g_miss_char,
86: relative_st_date_event_id okc_deliverables.relative_st_date_event_id%TYPE
87: := okc_api.g_miss_num,
88: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
89: := okc_api.g_miss_num,
90: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
91: := okc_api.g_miss_char,
92: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
93: := okc_api.g_miss_num,
87: := okc_api.g_miss_num,
88: relative_end_date_duration okc_deliverables.relative_end_date_duration%TYPE
89: := okc_api.g_miss_num,
90: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
91: := okc_api.g_miss_char,
92: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
93: := okc_api.g_miss_num,
94: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
95: := okc_api.g_miss_char,
89: := okc_api.g_miss_num,
90: relative_end_date_uom okc_deliverables.relative_end_date_uom%TYPE
91: := okc_api.g_miss_char,
92: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
93: := okc_api.g_miss_num,
94: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
95: := okc_api.g_miss_char,
96: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
97: := okc_api.g_miss_char,
91: := okc_api.g_miss_char,
92: relative_end_date_event_id okc_deliverables.relative_end_date_event_id%TYPE
93: := okc_api.g_miss_num,
94: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
95: := okc_api.g_miss_char,
96: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
97: := okc_api.g_miss_char,
98: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
99: := okc_api.g_miss_char,
93: := okc_api.g_miss_num,
94: repeating_day_of_month okc_deliverables.repeating_day_of_month%TYPE
95: := okc_api.g_miss_char,
96: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
97: := okc_api.g_miss_char,
98: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
99: := okc_api.g_miss_char,
100: repeating_duration okc_deliverables.repeating_duration%TYPE
101: := okc_api.g_miss_num,
95: := okc_api.g_miss_char,
96: repeating_day_of_week okc_deliverables.repeating_day_of_week%TYPE
97: := okc_api.g_miss_char,
98: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
99: := okc_api.g_miss_char,
100: repeating_duration okc_deliverables.repeating_duration%TYPE
101: := okc_api.g_miss_num,
102: fixed_start_date okc_deliverables.fixed_start_date%TYPE
103: := okc_api.g_miss_date,
97: := okc_api.g_miss_char,
98: repeating_frequency_uom okc_deliverables.repeating_frequency_uom%TYPE
99: := okc_api.g_miss_char,
100: repeating_duration okc_deliverables.repeating_duration%TYPE
101: := okc_api.g_miss_num,
102: fixed_start_date okc_deliverables.fixed_start_date%TYPE
103: := okc_api.g_miss_date,
104: fixed_end_date okc_deliverables.fixed_end_date%TYPE
105: := okc_api.g_miss_date,
99: := okc_api.g_miss_char,
100: repeating_duration okc_deliverables.repeating_duration%TYPE
101: := okc_api.g_miss_num,
102: fixed_start_date okc_deliverables.fixed_start_date%TYPE
103: := okc_api.g_miss_date,
104: fixed_end_date okc_deliverables.fixed_end_date%TYPE
105: := okc_api.g_miss_date,
106: manage_yn okc_deliverables.manage_yn%TYPE
107: := okc_api.g_miss_char,
101: := okc_api.g_miss_num,
102: fixed_start_date okc_deliverables.fixed_start_date%TYPE
103: := okc_api.g_miss_date,
104: fixed_end_date okc_deliverables.fixed_end_date%TYPE
105: := okc_api.g_miss_date,
106: manage_yn okc_deliverables.manage_yn%TYPE
107: := okc_api.g_miss_char,
108: internal_party_id okc_deliverables.internal_party_id%TYPE
109: := okc_api.g_miss_num,
103: := okc_api.g_miss_date,
104: fixed_end_date okc_deliverables.fixed_end_date%TYPE
105: := okc_api.g_miss_date,
106: manage_yn okc_deliverables.manage_yn%TYPE
107: := okc_api.g_miss_char,
108: internal_party_id okc_deliverables.internal_party_id%TYPE
109: := okc_api.g_miss_num,
110: deliverable_status okc_deliverables.deliverable_status%TYPE
111: := okc_api.g_miss_char,
105: := okc_api.g_miss_date,
106: manage_yn okc_deliverables.manage_yn%TYPE
107: := okc_api.g_miss_char,
108: internal_party_id okc_deliverables.internal_party_id%TYPE
109: := okc_api.g_miss_num,
110: deliverable_status okc_deliverables.deliverable_status%TYPE
111: := okc_api.g_miss_char,
112: status_change_notes okc_deliverables.status_change_notes%TYPE
113: := okc_api.g_miss_char,
107: := okc_api.g_miss_char,
108: internal_party_id okc_deliverables.internal_party_id%TYPE
109: := okc_api.g_miss_num,
110: deliverable_status okc_deliverables.deliverable_status%TYPE
111: := okc_api.g_miss_char,
112: status_change_notes okc_deliverables.status_change_notes%TYPE
113: := okc_api.g_miss_char,
114: created_by NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
109: := okc_api.g_miss_num,
110: deliverable_status okc_deliverables.deliverable_status%TYPE
111: := okc_api.g_miss_char,
112: status_change_notes okc_deliverables.status_change_notes%TYPE
113: := okc_api.g_miss_char,
114: created_by NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
110: deliverable_status okc_deliverables.deliverable_status%TYPE
111: := okc_api.g_miss_char,
112: status_change_notes okc_deliverables.status_change_notes%TYPE
113: := okc_api.g_miss_char,
114: created_by NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
112: status_change_notes okc_deliverables.status_change_notes%TYPE
113: := okc_api.g_miss_char,
114: created_by NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
113: := okc_api.g_miss_char,
114: created_by NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
121: object_version_number NUMBER := okc_api.g_miss_num,
115: creation_date okc_deliverables.creation_date%TYPE
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
121: object_version_number NUMBER := okc_api.g_miss_num,
122: attribute_category okc_deliverables.attribute_category%TYPE
123: := okc_api.g_miss_char,
116: := okc_api.g_miss_date,
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
121: object_version_number NUMBER := okc_api.g_miss_num,
122: attribute_category okc_deliverables.attribute_category%TYPE
123: := okc_api.g_miss_char,
124: attribute1 okc_deliverables.attribute1%TYPE
117: last_updated_by NUMBER := okc_api.g_miss_num,
118: last_update_date okc_deliverables.last_update_date%TYPE
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
121: object_version_number NUMBER := okc_api.g_miss_num,
122: attribute_category okc_deliverables.attribute_category%TYPE
123: := okc_api.g_miss_char,
124: attribute1 okc_deliverables.attribute1%TYPE
125: := okc_api.g_miss_char,
119: := okc_api.g_miss_date,
120: last_update_login NUMBER := okc_api.g_miss_num,
121: object_version_number NUMBER := okc_api.g_miss_num,
122: attribute_category okc_deliverables.attribute_category%TYPE
123: := okc_api.g_miss_char,
124: attribute1 okc_deliverables.attribute1%TYPE
125: := okc_api.g_miss_char,
126: attribute2 okc_deliverables.attribute2%TYPE
127: := okc_api.g_miss_char,
121: object_version_number NUMBER := okc_api.g_miss_num,
122: attribute_category okc_deliverables.attribute_category%TYPE
123: := okc_api.g_miss_char,
124: attribute1 okc_deliverables.attribute1%TYPE
125: := okc_api.g_miss_char,
126: attribute2 okc_deliverables.attribute2%TYPE
127: := okc_api.g_miss_char,
128: attribute3 okc_deliverables.attribute3%TYPE
129: := okc_api.g_miss_char,
123: := okc_api.g_miss_char,
124: attribute1 okc_deliverables.attribute1%TYPE
125: := okc_api.g_miss_char,
126: attribute2 okc_deliverables.attribute2%TYPE
127: := okc_api.g_miss_char,
128: attribute3 okc_deliverables.attribute3%TYPE
129: := okc_api.g_miss_char,
130: attribute4 okc_deliverables.attribute4%TYPE
131: := okc_api.g_miss_char,
125: := okc_api.g_miss_char,
126: attribute2 okc_deliverables.attribute2%TYPE
127: := okc_api.g_miss_char,
128: attribute3 okc_deliverables.attribute3%TYPE
129: := okc_api.g_miss_char,
130: attribute4 okc_deliverables.attribute4%TYPE
131: := okc_api.g_miss_char,
132: attribute5 okc_deliverables.attribute5%TYPE
133: := okc_api.g_miss_char,
127: := okc_api.g_miss_char,
128: attribute3 okc_deliverables.attribute3%TYPE
129: := okc_api.g_miss_char,
130: attribute4 okc_deliverables.attribute4%TYPE
131: := okc_api.g_miss_char,
132: attribute5 okc_deliverables.attribute5%TYPE
133: := okc_api.g_miss_char,
134: attribute6 okc_deliverables.attribute6%TYPE
135: := okc_api.g_miss_char,
129: := okc_api.g_miss_char,
130: attribute4 okc_deliverables.attribute4%TYPE
131: := okc_api.g_miss_char,
132: attribute5 okc_deliverables.attribute5%TYPE
133: := okc_api.g_miss_char,
134: attribute6 okc_deliverables.attribute6%TYPE
135: := okc_api.g_miss_char,
136: attribute7 okc_deliverables.attribute7%TYPE
137: := okc_api.g_miss_char,
131: := okc_api.g_miss_char,
132: attribute5 okc_deliverables.attribute5%TYPE
133: := okc_api.g_miss_char,
134: attribute6 okc_deliverables.attribute6%TYPE
135: := okc_api.g_miss_char,
136: attribute7 okc_deliverables.attribute7%TYPE
137: := okc_api.g_miss_char,
138: attribute8 okc_deliverables.attribute8%TYPE
139: := okc_api.g_miss_char,
133: := okc_api.g_miss_char,
134: attribute6 okc_deliverables.attribute6%TYPE
135: := okc_api.g_miss_char,
136: attribute7 okc_deliverables.attribute7%TYPE
137: := okc_api.g_miss_char,
138: attribute8 okc_deliverables.attribute8%TYPE
139: := okc_api.g_miss_char,
140: attribute9 okc_deliverables.attribute9%TYPE
141: := okc_api.g_miss_char,
135: := okc_api.g_miss_char,
136: attribute7 okc_deliverables.attribute7%TYPE
137: := okc_api.g_miss_char,
138: attribute8 okc_deliverables.attribute8%TYPE
139: := okc_api.g_miss_char,
140: attribute9 okc_deliverables.attribute9%TYPE
141: := okc_api.g_miss_char,
142: attribute10 okc_deliverables.attribute10%TYPE
143: := okc_api.g_miss_char,
137: := okc_api.g_miss_char,
138: attribute8 okc_deliverables.attribute8%TYPE
139: := okc_api.g_miss_char,
140: attribute9 okc_deliverables.attribute9%TYPE
141: := okc_api.g_miss_char,
142: attribute10 okc_deliverables.attribute10%TYPE
143: := okc_api.g_miss_char,
144: attribute11 okc_deliverables.attribute11%TYPE
145: := okc_api.g_miss_char,
139: := okc_api.g_miss_char,
140: attribute9 okc_deliverables.attribute9%TYPE
141: := okc_api.g_miss_char,
142: attribute10 okc_deliverables.attribute10%TYPE
143: := okc_api.g_miss_char,
144: attribute11 okc_deliverables.attribute11%TYPE
145: := okc_api.g_miss_char,
146: attribute12 okc_deliverables.attribute12%TYPE
147: := okc_api.g_miss_char,
141: := okc_api.g_miss_char,
142: attribute10 okc_deliverables.attribute10%TYPE
143: := okc_api.g_miss_char,
144: attribute11 okc_deliverables.attribute11%TYPE
145: := okc_api.g_miss_char,
146: attribute12 okc_deliverables.attribute12%TYPE
147: := okc_api.g_miss_char,
148: attribute13 okc_deliverables.attribute13%TYPE
149: := okc_api.g_miss_char,
143: := okc_api.g_miss_char,
144: attribute11 okc_deliverables.attribute11%TYPE
145: := okc_api.g_miss_char,
146: attribute12 okc_deliverables.attribute12%TYPE
147: := okc_api.g_miss_char,
148: attribute13 okc_deliverables.attribute13%TYPE
149: := okc_api.g_miss_char,
150: attribute14 okc_deliverables.attribute14%TYPE
151: := okc_api.g_miss_char,
145: := okc_api.g_miss_char,
146: attribute12 okc_deliverables.attribute12%TYPE
147: := okc_api.g_miss_char,
148: attribute13 okc_deliverables.attribute13%TYPE
149: := okc_api.g_miss_char,
150: attribute14 okc_deliverables.attribute14%TYPE
151: := okc_api.g_miss_char,
152: attribute15 okc_deliverables.attribute15%TYPE
153: := okc_api.g_miss_char,
147: := okc_api.g_miss_char,
148: attribute13 okc_deliverables.attribute13%TYPE
149: := okc_api.g_miss_char,
150: attribute14 okc_deliverables.attribute14%TYPE
151: := okc_api.g_miss_char,
152: attribute15 okc_deliverables.attribute15%TYPE
153: := okc_api.g_miss_char,
154: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
155: := okc_api.g_miss_char,
149: := okc_api.g_miss_char,
150: attribute14 okc_deliverables.attribute14%TYPE
151: := okc_api.g_miss_char,
152: attribute15 okc_deliverables.attribute15%TYPE
153: := okc_api.g_miss_char,
154: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
155: := okc_api.g_miss_char,
156: last_amendment_date okc_deliverables.last_amendment_date%TYPE
157: := okc_api.g_miss_date,
151: := okc_api.g_miss_char,
152: attribute15 okc_deliverables.attribute15%TYPE
153: := okc_api.g_miss_char,
154: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
155: := okc_api.g_miss_char,
156: last_amendment_date okc_deliverables.last_amendment_date%TYPE
157: := okc_api.g_miss_date,
158: business_document_line_id okc_deliverables.business_document_line_id%TYPE
159: := okc_api.g_miss_num,
153: := okc_api.g_miss_char,
154: disable_notifications_yn okc_deliverables.disable_notifications_yn%TYPE
155: := okc_api.g_miss_char,
156: last_amendment_date okc_deliverables.last_amendment_date%TYPE
157: := okc_api.g_miss_date,
158: business_document_line_id okc_deliverables.business_document_line_id%TYPE
159: := okc_api.g_miss_num,
160: external_party_site_id okc_deliverables.external_party_site_id%TYPE
161: := okc_api.g_miss_num,
155: := okc_api.g_miss_char,
156: last_amendment_date okc_deliverables.last_amendment_date%TYPE
157: := okc_api.g_miss_date,
158: business_document_line_id okc_deliverables.business_document_line_id%TYPE
159: := okc_api.g_miss_num,
160: external_party_site_id okc_deliverables.external_party_site_id%TYPE
161: := okc_api.g_miss_num,
162: start_event_date okc_deliverables.start_event_date%TYPE
163: := okc_api.g_miss_date,
157: := okc_api.g_miss_date,
158: business_document_line_id okc_deliverables.business_document_line_id%TYPE
159: := okc_api.g_miss_num,
160: external_party_site_id okc_deliverables.external_party_site_id%TYPE
161: := okc_api.g_miss_num,
162: start_event_date okc_deliverables.start_event_date%TYPE
163: := okc_api.g_miss_date,
164: end_event_date okc_deliverables.end_event_date%TYPE
165: := okc_api.g_miss_date,
159: := okc_api.g_miss_num,
160: external_party_site_id okc_deliverables.external_party_site_id%TYPE
161: := okc_api.g_miss_num,
162: start_event_date okc_deliverables.start_event_date%TYPE
163: := okc_api.g_miss_date,
164: end_event_date okc_deliverables.end_event_date%TYPE
165: := okc_api.g_miss_date,
166: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
167: := okc_api.g_miss_char,
161: := okc_api.g_miss_num,
162: start_event_date okc_deliverables.start_event_date%TYPE
163: := okc_api.g_miss_date,
164: end_event_date okc_deliverables.end_event_date%TYPE
165: := okc_api.g_miss_date,
166: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
167: := okc_api.g_miss_char,
168: external_party_role okc_deliverables.external_party_role%TYPE
169: := okc_api.g_miss_char,
163: := okc_api.g_miss_date,
164: end_event_date okc_deliverables.end_event_date%TYPE
165: := okc_api.g_miss_date,
166: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
167: := okc_api.g_miss_char,
168: external_party_role okc_deliverables.external_party_role%TYPE
169: := okc_api.g_miss_char,
170: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
171: := okc_api.g_miss_char,
165: := okc_api.g_miss_date,
166: summary_amend_operation_code okc_deliverables.summary_amend_operation_code%TYPE
167: := okc_api.g_miss_char,
168: external_party_role okc_deliverables.external_party_role%TYPE
169: := okc_api.g_miss_char,
170: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
171: := okc_api.g_miss_char,
172: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
173: := okc_api.g_miss_num,
167: := okc_api.g_miss_char,
168: external_party_role okc_deliverables.external_party_role%TYPE
169: := okc_api.g_miss_char,
170: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
171: := okc_api.g_miss_char,
172: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
173: := okc_api.g_miss_num,
174: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175: := okc_api.g_miss_char,
169: := okc_api.g_miss_char,
170: pay_hold_prior_due_date_yn okc_deliverables.pay_hold_prior_due_date_yn%TYPE
171: := okc_api.g_miss_char,
172: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
173: := okc_api.g_miss_num,
174: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175: := okc_api.g_miss_char,
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
171: := okc_api.g_miss_char,
172: pay_hold_prior_due_date_value okc_deliverables.pay_hold_prior_due_date_value%TYPE
173: := okc_api.g_miss_num,
174: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175: := okc_api.g_miss_char,
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
173: := okc_api.g_miss_num,
174: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175: := okc_api.g_miss_char,
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180: orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
174: pay_hold_prior_due_date_uom okc_deliverables.pay_hold_prior_due_date_uom%TYPE
175: := okc_api.g_miss_char,
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180: orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
182: status VARCHAR2 (1),
175: := okc_api.g_miss_char,
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180: orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
182: status VARCHAR2 (1),
183: errmsg VARCHAR2 (2500)
176: pay_hold_overdue_yn okc_deliverables.pay_hold_overdue_yn%TYPE
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180: orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
182: status VARCHAR2 (1),
183: errmsg VARCHAR2 (2500)
184: );
177: := okc_api.g_miss_char,
178: orig_system_reference_code okc_deliverables.orig_system_reference_code%TYPE := okc_api.g_miss_char,
179: orig_system_reference_id1 okc_deliverables.orig_system_reference_id1%TYPE := okc_api.g_miss_num,
180: orig_system_reference_id2 okc_deliverables.orig_system_reference_id2%TYPE := okc_api.g_miss_num,
181: raise_completion_event_yn okc_deliverables.raise_completion_event_yn%TYPE := okc_api.g_miss_char,
182: status VARCHAR2 (1),
183: errmsg VARCHAR2 (2500)
184: );
185: