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 54: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 75: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 76: p_notes IN CS_ServiceRequest_PVT.notes_table,

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

Line 77: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,

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

Line 93: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 114: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 116: p_notes IN CS_ServiceRequest_PVT.notes_table,

112: p_last_update_date IN DATE,
113: p_invocation_mode IN VARCHAR2 := 'NORMAL',
114: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
115: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_notes IN CS_ServiceRequest_PVT.notes_table,
117: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
118: p_audit_comments IN VARCHAR2 DEFAULT NULL,
119: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
120: p_workflow_process_id IN NUMBER DEFAULT NULL,

Line 117: p_contacts IN CS_ServiceRequest_PVT.contacts_table,

113: p_invocation_mode IN VARCHAR2 := 'NORMAL',
114: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
115: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_notes IN CS_ServiceRequest_PVT.notes_table,
117: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
118: p_audit_comments IN VARCHAR2 DEFAULT NULL,
119: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
120: p_workflow_process_id IN NUMBER DEFAULT NULL,
121: x_workflow_process_id OUT NOCOPY NUMBER,

Line 133: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 154: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,

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

Line 156: p_notes IN CS_ServiceRequest_PVT.notes_table,

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

Line 157: p_contacts IN CS_ServiceRequest_PVT.contacts_table,

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

Line 170: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)

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

Line 176: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)

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