APPS.CS_ROUTING_UTL dependencies on CS_INCIDENTS_ALL

Line 10: -- CS_INCIDENTS_ALL table given a service request number.

6: -- Function : Get_Customer_From_RequestNum
7: -- Usage : Used by the Routing module to get the customer ID from the
8: -- service request number
9: -- Description : This function retrieves a customer ID from the
10: -- CS_INCIDENTS_ALL table given a service request number.
11: -- Parameters :
12: -- p_request_number IN VARCHAR2(64) Required
13: --
14: -- Return : NUMBER

Line 24: p_customer_id cs_incidents_all.customer_id%type;

20:
21: FUNCTION Get_Customer_From_RequestNum
22: ( p_request_number IN VARCHAR2)
23: RETURN NUMBER IS
24: p_customer_id cs_incidents_all.customer_id%type;
25:
26: --
27: -- get customer ID given a requesr number
28: --

Line 31: FROM cs_incidents_all

27: -- get customer ID given a requesr number
28: --
29: CURSOR c_customer_id IS
30: SELECT customer_id
31: FROM cs_incidents_all
32: WHERE incident_number = p_request_number;
33: BEGIN
34:
35: OPEN c_customer_id;

Line 129: -- CS_INCIDENTS_ALL table given a service request number.

125: -- Function : Get_CP_From_RequestNum
126: -- Usage : Used by the Routing module to get the customer product ID
127: -- from the service request number
128: -- Description : This function retrieves a customer product ID from the
129: -- CS_INCIDENTS_ALL table given a service request number.
130: -- Parameters :
131: -- p_request_number IN VARCHAR2(64) Required
132: --
133: -- Return : NUMBER

Line 143: p_customer_product_id cs_incidents_all.customer_product_id%type;

139: FUNCTION Get_CP_From_RequestNum
140: ( p_request_number IN VARCHAR2)
141: RETURN NUMBER IS
142:
143: p_customer_product_id cs_incidents_all.customer_product_id%type;
144:
145: --
146: -- get customer product ID given a request number
147: --

Line 150: FROM cs_incidents_all

146: -- get customer product ID given a request number
147: --
148: CURSOR c_customer_product_id IS
149: SELECT customer_product_id
150: FROM cs_incidents_all
151: WHERE incident_number = p_request_number;
152:
153: BEGIN
154:

Line 213: -- CS_INCIDENTS_ALL table given a service request number.

209: -- Function : Get_Product_From_RequestNum
210: -- Usage : Used by the Routing module to get the inventory item ID
211: -- from the service request number
212: -- Description : This function retrieves an inventory item ID from the
213: -- CS_INCIDENTS_ALL table given a service request number.
214: -- Parameters :
215: -- p_request_number IN VARCHAR2(64) Required
216: --
217: -- Return : NUMBER

Line 226: p_inventory_item_id cs_incidents_all.inventory_item_id%type;

222:
223: FUNCTION Get_Product_From_RequestNum
224: ( p_request_number IN VARCHAR2)
225: RETURN NUMBER IS
226: p_inventory_item_id cs_incidents_all.inventory_item_id%type;
227:
228: --
229: -- get inventory item ID given a request number
230: --

Line 233: FROM cs_incidents_all

229: -- get inventory item ID given a request number
230: --
231: CURSOR c_inventory_item_id IS
232: SELECT inventory_item_id
233: FROM cs_incidents_all
234: WHERE incident_number = p_request_number;
235: BEGIN
236:
237: OPEN c_inventory_item_id;

Line 290: -- CS_INCIDENTS_ALL table given a service request number.

286: ------------------------------------------------------------------------------
287: -- Function : Get_Owner_Of_Request
288: -- Usage : Used by the Routing module to get the service request owner
289: -- Description : This function retrieves the employee ID from the
290: -- CS_INCIDENTS_ALL table given a service request number.
291: -- Parameters :
292: -- p_request_number IN VARCHAR2(64) Required
293: --
294: -- Return : NUMBER

Line 303: p_employee_id cs_incidents_all.employee_id%type;

299: FUNCTION Get_Owner_Of_Request
300: ( p_request_number IN VARCHAR2)
301: RETURN NUMBER IS
302:
303: p_employee_id cs_incidents_all.employee_id%type;
304:
305: --
306: -- get owner given a request number
307: --

Line 310: FROM cs_incidents_all

306: -- get owner given a request number
307: --
308: CURSOR c_employee_id IS
309: SELECT employee_id
310: FROM cs_incidents_all
311: WHERE incident_number = p_request_number;
312: BEGIN
313:
314: OPEN c_employee_id;

Line 346: v_incident_type_id cs_incidents_all.incident_type_id%type;

342: RETURN NUMBER IS
343:
344: v_total_num_of_emps NUMBER:=0;
345: v_current_id cs_group_level_assigns.role_person_id%type;
346: v_incident_type_id cs_incidents_all.incident_type_id%type;
347:
348: --
349: -- get service request type given an incident ID
350: --

Line 353: FROM cs_incidents_all

349: -- get service request type given an incident ID
350: --
351: CURSOR c_incident_type_id IS
352: SELECT incident_type_id
353: FROM cs_incidents_all
354: WHERE incident_number = p_incident_number;
355:
356: --
357: -- get a list of employees that is responsible to a service request type