DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_VUHK dependencies on CS_SERVICEREQUEST_PVT

Line 16: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

12: create service request*/
13:
14: /*
15: PROCEDURE Create_ServiceRequest_Pre
16: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
17: x_return_status OUT NOCOPY VARCHAR2
18: ); */
19:
20:

Line 36: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

32: p_login_id IN NUMBER DEFAULT NULL,
33: p_org_id IN NUMBER DEFAULT NULL,
34: p_request_id IN NUMBER DEFAULT NULL,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
37: p_notes IN CS_ServiceRequest_PVT.notes_table,
38: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
39: x_request_id OUT NOCOPY NUMBER,
40: x_request_number OUT NOCOPY VARCHAR2,

Line 37: p_notes IN CS_ServiceRequest_PVT.notes_table,

33: p_org_id IN NUMBER DEFAULT NULL,
34: p_request_id IN NUMBER DEFAULT NULL,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
37: p_notes IN CS_ServiceRequest_PVT.notes_table,
38: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
39: x_request_id OUT NOCOPY NUMBER,
40: x_request_number OUT NOCOPY VARCHAR2,
41: x_interaction_id OUT NOCOPY NUMBER,

Line 38: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,

34: p_request_id IN NUMBER DEFAULT NULL,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
37: p_notes IN CS_ServiceRequest_PVT.notes_table,
38: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
39: x_request_id OUT NOCOPY NUMBER,
40: x_request_number OUT NOCOPY VARCHAR2,
41: x_interaction_id OUT NOCOPY NUMBER,
42: x_workflow_process_id OUT NOCOPY NUMBER

Line 51: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

47: create service request */
48:
49: /*
50: PROCEDURE Create_ServiceRequest_Post
51: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
52: x_return_status OUT NOCOPY VARCHAR2
53: ); */
54:
55:

Line 71: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

67: p_login_id IN NUMBER DEFAULT NULL,
68: p_org_id IN NUMBER DEFAULT NULL,
69: p_request_id IN NUMBER DEFAULT NULL,
70: p_request_number IN VARCHAR2 DEFAULT NULL,
71: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
72: p_notes IN CS_ServiceRequest_PVT.notes_table,
73: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
74: x_request_id OUT NOCOPY NUMBER,
75: x_request_number OUT NOCOPY VARCHAR2,

Line 72: p_notes IN CS_ServiceRequest_PVT.notes_table,

68: p_org_id IN NUMBER DEFAULT NULL,
69: p_request_id IN NUMBER DEFAULT NULL,
70: p_request_number IN VARCHAR2 DEFAULT NULL,
71: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
72: p_notes IN CS_ServiceRequest_PVT.notes_table,
73: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
74: x_request_id OUT NOCOPY NUMBER,
75: x_request_number OUT NOCOPY VARCHAR2,
76: x_interaction_id OUT NOCOPY NUMBER,

Line 73: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,

69: p_request_id IN NUMBER DEFAULT NULL,
70: p_request_number IN VARCHAR2 DEFAULT NULL,
71: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
72: p_notes IN CS_ServiceRequest_PVT.notes_table,
73: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
74: x_request_id OUT NOCOPY NUMBER,
75: x_request_number OUT NOCOPY VARCHAR2,
76: x_interaction_id OUT NOCOPY NUMBER,
77: x_workflow_process_id OUT NOCOPY NUMBER

Line 90: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

86:
87: /*
88: PROCEDURE Update_ServiceRequest_Pre
89: ( p_request_id IN NUMBER,
90: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
91: x_return_status OUT NOCOPY VARCHAR2
92: ); */
93:
94:

Line 112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

108: p_resp_id IN NUMBER DEFAULT NULL,
109: p_last_updated_by IN NUMBER,
110: p_last_update_login IN NUMBER DEFAULT NULL,
111: p_last_update_date IN DATE,
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,

Line 114: p_notes IN CS_ServiceRequest_PVT.notes_table,

110: p_last_update_login IN NUMBER DEFAULT NULL,
111: p_last_update_date IN DATE,
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,
117: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
118: p_workflow_process_id IN NUMBER DEFAULT NULL,

Line 115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,

111: p_last_update_date IN DATE,
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,
117: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
118: p_workflow_process_id IN NUMBER DEFAULT NULL,
119: x_workflow_process_id OUT NOCOPY NUMBER,

Line 140: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

136:
137: /*
138: PROCEDURE Update_ServiceRequest_Post
139: ( p_request_id IN NUMBER,
140: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
141: x_return_status OUT NOCOPY VARCHAR2
142: ); */
143:
144:

Line 160: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

156: p_resp_id IN NUMBER DEFAULT NULL,
157: p_last_updated_by IN NUMBER,
158: p_last_update_login IN NUMBER DEFAULT NULL,
159: p_last_update_date IN DATE,
160: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
161: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
162: p_notes IN CS_ServiceRequest_PVT.notes_table,
163: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
164: p_audit_comments IN VARCHAR2 DEFAULT NULL,

Line 162: p_notes IN CS_ServiceRequest_PVT.notes_table,

158: p_last_update_login IN NUMBER DEFAULT NULL,
159: p_last_update_date IN DATE,
160: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
161: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
162: p_notes IN CS_ServiceRequest_PVT.notes_table,
163: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
164: p_audit_comments IN VARCHAR2 DEFAULT NULL,
165: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
166: p_workflow_process_id IN NUMBER DEFAULT NULL,

Line 163: p_contacts IN CS_ServiceRequest_PVT.contacts_table,

159: p_last_update_date IN DATE,
160: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
161: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
162: p_notes IN CS_ServiceRequest_PVT.notes_table,
163: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
164: p_audit_comments IN VARCHAR2 DEFAULT NULL,
165: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
166: p_workflow_process_id IN NUMBER DEFAULT NULL,
167: x_workflow_process_id OUT NOCOPY NUMBER,