21: -- End of comments
22:
23: PROCEDURE Create_Escalation_Pre(
24: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
25: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
26: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
27: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
28: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
29: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
22:
23: PROCEDURE Create_Escalation_Pre(
24: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
25: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
26: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
27: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
28: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
29: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
30: x_return_status OUT NOCOPY VARCHAR2,
23: PROCEDURE Create_Escalation_Pre(
24: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
25: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
26: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
27: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
28: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
29: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
24: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
25: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
26: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
27: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
28: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
29: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2) Is
25: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
26: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
27: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
28: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
29: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2) Is
33:
37:
38:
39: PROCEDURE Create_Escalation_Post(
40: p_esc_id IN jtf_tasks_b.task_id%TYPE,
41: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
38:
39: PROCEDURE Create_Escalation_Post(
40: p_esc_id IN jtf_tasks_b.task_id%TYPE,
41: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
46: x_return_status OUT NOCOPY VARCHAR2,
39: PROCEDURE Create_Escalation_Post(
40: p_esc_id IN jtf_tasks_b.task_id%TYPE,
41: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
40: p_esc_id IN jtf_tasks_b.task_id%TYPE,
41: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2) Is
41: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2) Is
49:
54: PROCEDURE Update_Escalation_Pre(
55: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
56: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
57: p_object_version IN OUT NOCOPY NUMBER,
58: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
59: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
60: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
61: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
62: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
55: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
56: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
57: p_object_version IN OUT NOCOPY NUMBER,
58: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
59: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
60: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
61: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
62: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
63: x_return_status OUT NOCOPY VARCHAR2,
56: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
57: p_object_version IN OUT NOCOPY NUMBER,
58: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
59: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
60: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
61: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
62: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
57: p_object_version IN OUT NOCOPY NUMBER,
58: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
59: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
60: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
61: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
62: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2) Is
58: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
59: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
60: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
61: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
62: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2) Is
66:
71: PROCEDURE Update_Escalation_Post(
72: p_esc_id IN jtf_tasks_b.task_id%TYPE,
73: p_esc_number IN jtf_tasks_b.task_number%TYPE,
74: p_object_version IN NUMBER,
75: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
72: p_esc_id IN jtf_tasks_b.task_id%TYPE,
73: p_esc_number IN jtf_tasks_b.task_number%TYPE,
74: p_object_version IN NUMBER,
75: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
80: x_return_status OUT NOCOPY VARCHAR2,
73: p_esc_number IN jtf_tasks_b.task_number%TYPE,
74: p_object_version IN NUMBER,
75: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
74: p_object_version IN NUMBER,
75: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2) Is
75: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2) Is
83: