DBA Data[Home] [Help]

APPS.JTF_EC_VUHK dependencies on JTF_EC_PUB

Line 14: -- Parameters : Please look at the JTF_EC_PUB api for the parameters description

10: -- Function : This is a Vertical Industry User Hooks API.
11: -- The Vertical Industry can add customization procedures here
12: -- for Pre and Post Processing.
13: -- Pre-reqs : None.
14: -- Parameters : Please look at the JTF_EC_PUB api for the parameters description
15: -- name direction type required?
16: -- ---- --------- ---- ---------
17: -- x_return_status OUT VARCHAR2 required
18: -- x_msg_count OUT NUMBER required

Line 41: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,

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

Line 42: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

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

Line 43: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,

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

Line 44: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

40: p_esc_id IN OUT NOCOPY jtf_tasks_b.task_id%TYPE,
41: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN OUT NOCOPY 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);

Line 45: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

41: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
42: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
43: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
44: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
45: p_notes IN OUT NOCOPY 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);
49:

Line 57: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,

53:
54:
55: PROCEDURE Create_Escalation_Post(
56: p_esc_id IN jtf_tasks_b.task_id%TYPE,
57: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

Line 58: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

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

Line 59: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,

55: PROCEDURE Create_Escalation_Post(
56: p_esc_id IN jtf_tasks_b.task_id%TYPE,
57: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN 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 jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

56: p_esc_id IN jtf_tasks_b.task_id%TYPE,
57: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN 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);

Line 61: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

57: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
58: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
59: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
60: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
61: p_notes IN 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);
65:

Line 75: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,

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

Line 76: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

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

Line 77: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,

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

Line 78: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

74: p_object_version IN OUT NOCOPY NUMBER,
75: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN OUT NOCOPY 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);

Line 79: p_notes IN OUT NOCOPY jtf_ec_pub.Notes_Tbl_Type,

75: p_esc_record IN OUT NOCOPY jtf_ec_pub.Esc_Rec_Type,
76: p_reference_documents IN OUT NOCOPY jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
77: p_esc_contacts IN OUT NOCOPY jtf_ec_pub.Esc_Contacts_Tbl_Type,
78: p_cont_points IN OUT NOCOPY jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
79: p_notes IN OUT NOCOPY 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);
83:

Line 92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,

88: PROCEDURE Update_Escalation_Post(
89: p_esc_id IN jtf_tasks_b.task_id%TYPE,
90: p_esc_number IN jtf_tasks_b.task_number%TYPE,
91: p_object_version IN NUMBER,
92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

Line 93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,

89: p_esc_id IN jtf_tasks_b.task_id%TYPE,
90: p_esc_number IN jtf_tasks_b.task_number%TYPE,
91: p_object_version IN NUMBER,
92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
97: x_return_status OUT NOCOPY VARCHAR2,

Line 94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,

90: p_esc_number IN jtf_tasks_b.task_number%TYPE,
91: p_object_version IN NUMBER,
92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,

Line 95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,

91: p_object_version IN NUMBER,
92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2);

Line 96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,

92: p_esc_record IN jtf_ec_pub.Esc_Rec_Type,
93: p_reference_documents IN jtf_ec_pub.Esc_Ref_Docs_Tbl_Type,
94: p_esc_contacts IN jtf_ec_pub.Esc_Contacts_Tbl_Type,
95: p_cont_points IN jtf_ec_pub.Esc_Cont_Points_Tbl_Type,
96: p_notes IN jtf_ec_pub.Notes_Tbl_Type,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2);
100: