DBA Data[Home] [Help]

APPS.JTF_EC_CUHK dependencies on JTF_TASKS_B

Line 23: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,

19: --
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,

Line 39: p_esc_id IN jtf_tasks_b.task_id%TYPE,

35: END;
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,

Line 54: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,

50: null;
51: END;
52:
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,

Line 55: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,

51: END;
52:
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,

Line 71: p_esc_id IN jtf_tasks_b.task_id%TYPE,

67: null;
68: END;
69:
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,

Line 72: p_esc_number IN jtf_tasks_b.task_number%TYPE,

68: END;
69:
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,

Line 88: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,

84: null;
85: END;
86:
87: PROCEDURE Delete_Escalation_Pre(
88: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
89: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
90: p_object_version IN OUT NOCOPY NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,

Line 89: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,

85: END;
86:
87: PROCEDURE Delete_Escalation_Pre(
88: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
89: p_esc_number IN OUT NOCOPY jtf_tasks_b.task_number%TYPE,
90: p_object_version IN OUT NOCOPY NUMBER,
91: x_return_status OUT NOCOPY VARCHAR2,
92: x_msg_count OUT NOCOPY NUMBER,
93: x_msg_data OUT NOCOPY VARCHAR2) Is

Line 100: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,

96: null;
97: END;
98:
99: PROCEDURE Delete_Escalation_Post(
100: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
101: p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
102: p_object_version IN NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

Line 101: p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,

97: END;
98:
99: PROCEDURE Delete_Escalation_Post(
100: p_esc_id IN jtf_tasks_b.task_id%TYPE :=NULL,
101: p_esc_number IN jtf_tasks_b.task_number%TYPE :=NULL,
102: p_object_version IN NUMBER,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2) Is