APPS.JTF_EC_CUHK dependencies on JTF_EC_PUB

Line 24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,

20: -- End of comments
21:
22: PROCEDURE Create_Escalation_Pre(
23: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

Line 25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

21:
22: PROCEDURE Create_Escalation_Pre(
23: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
29: x_return_status OUT NOCOPY VARCHAR2,

Line 26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,

22: PROCEDURE Create_Escalation_Pre(
23: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,

Line 27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

23: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2) Is

Line 28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

24: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
25: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
26: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
27: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
28: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_data OUT NOCOPY VARCHAR2) Is
32:

Line 40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,

36:
37:
38: PROCEDURE Create_Escalation_Post(
39: p_esc_id IN jtf_tasks_b.task_id%TYPE,
40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

Line 41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

37:
38: PROCEDURE Create_Escalation_Post(
39: p_esc_id IN jtf_tasks_b.task_id%TYPE,
40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
45: x_return_status OUT NOCOPY VARCHAR2,

Line 42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,

38: PROCEDURE Create_Escalation_Post(
39: p_esc_id IN jtf_tasks_b.task_id%TYPE,
40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,

Line 43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

39: p_esc_id IN jtf_tasks_b.task_id%TYPE,
40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2) Is

Line 44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

40: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
41: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
42: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
43: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
44: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2) Is
48:

Line 57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,

53: PROCEDURE Update_Escalation_Pre(
54: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
55: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
56: p_object_version IN OUT NOCOPY NUMBER,
57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

Line 58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

54: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
55: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
56: p_object_version IN OUT NOCOPY NUMBER,
57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
62: x_return_status OUT NOCOPY VARCHAR2,

Line 59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,

55: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
56: p_object_version IN OUT NOCOPY NUMBER,
57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,

Line 60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

56: p_object_version IN OUT NOCOPY NUMBER,
57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2) Is

Line 61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

57: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2) Is
65:

Line 74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,

70: PROCEDURE Update_Escalation_Post(
71: p_esc_id IN jtf_tasks_b.task_id%TYPE,
72: p_esc_number IN jtf_tasks_b.task_number%TYPE,
73: p_object_version IN NUMBER,
74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

Line 75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

71: p_esc_id IN jtf_tasks_b.task_id%TYPE,
72: p_esc_number IN jtf_tasks_b.task_number%TYPE,
73: p_object_version IN NUMBER,
74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,

Line 76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,

72: p_esc_number IN jtf_tasks_b.task_number%TYPE,
73: p_object_version IN NUMBER,
74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,

Line 77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

73: p_object_version IN NUMBER,
74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2) Is

Line 78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

74: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
75: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
76: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
77: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
78: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2) Is
82: