DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_CUHK dependencies on CS_SERVICEREQUEST_PVT

Line 17: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 37: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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_invocation_mode IN VARCHAR2 := 'NORMAL',
37: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38: p_notes IN CS_ServiceRequest_PVT.notes_table,
39: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40: x_request_id OUT NOCOPY NUMBER,
41: x_request_number OUT NOCOPY VARCHAR2,

Line 38: p_notes IN CS_ServiceRequest_PVT.notes_table,

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

Line 39: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,

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

Line 52: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 73: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 74: p_notes IN CS_ServiceRequest_PVT.notes_table,

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

Line 75: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,

71: p_request_number IN VARCHAR2 DEFAULT NULL,
72: p_invocation_mode IN VARCHAR2 := 'NORMAL',
73: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
74: p_notes IN CS_ServiceRequest_PVT.notes_table,
75: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
76: x_request_id OUT NOCOPY NUMBER,
77: x_request_number OUT NOCOPY VARCHAR2,
78: x_interaction_id OUT NOCOPY NUMBER,
79: x_workflow_process_id OUT NOCOPY NUMBER

Line 91: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

108: p_last_updated_by IN NUMBER,
109: p_last_update_login IN NUMBER DEFAULT NULL,
110: p_last_update_date IN DATE,
111: p_invocation_mode IN VARCHAR2 := 'NORMAL',
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_date IN DATE,
111: p_invocation_mode IN VARCHAR2 := 'NORMAL',
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_invocation_mode IN VARCHAR2 := 'NORMAL',
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 131: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

127:
128: /*
129: PROCEDURE Update_ServiceRequest_Post
130: ( p_request_id IN NUMBER,
131: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
132: x_return_status OUT NOCOPY VARCHAR2); */
133:
134:
135:

Line 152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

148: p_last_updated_by IN NUMBER,
149: p_last_update_login IN NUMBER DEFAULT NULL,
150: p_last_update_date IN DATE,
151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,

Line 154: p_notes IN CS_ServiceRequest_PVT.notes_table,

150: p_last_update_date IN DATE,
151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,
157: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
158: p_workflow_process_id IN NUMBER DEFAULT NULL,

Line 155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,

151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,
157: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
158: p_workflow_process_id IN NUMBER DEFAULT NULL,
159: x_workflow_process_id OUT NOCOPY NUMBER,

Line 168: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)

164:
165:
166: FUNCTION Ok_To_Generate_Msg
167: (p_request_id IN NUMBER,
168: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
169: RETURN BOOLEAN ;
170:
171:
172: FUNCTION Ok_To_Launch_Workflow

Line 174: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)

170:
171:
172: FUNCTION Ok_To_Launch_Workflow
173: ( p_request_id IN NUMBER,
174: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
175: RETURN BOOLEAN ;
176:
177: END cs_servicerequest_cuhk;