APPS.CS_ROUTING_UTL dependencies on CS_CUSTOMER_PRODUCTS_ALL

Line 50: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a

46: -- Function : Get_Customer_From_SerialNum
47: -- Usage : Used by the Routing module to get the customer ID from the
48: -- serial number
49: -- Description : This function retrieves a customer ID from the
50: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a
51: -- product. If there are more than one customer associated
52: -- with the given serial number, this function will return the
53: -- first customer ID that it retrieves.
54: -- Parameters :

Line 65: p_customer_id cs_customer_products_all.customer_id%type;

61:
62: FUNCTION Get_Customer_From_SerialNum
63: ( p_serial_number IN VARCHAR2)
64: RETURN NUMBER IS
65: p_customer_id cs_customer_products_all.customer_id%type;
66:
67: --
68: -- get customer ID given a serial number
69: --

Line 72: FROM cs_customer_products_all

68: -- get customer ID given a serial number
69: --
70: CURSOR c_customer_id IS
71: SELECT customer_id
72: FROM cs_customer_products_all
73: WHERE current_serial_number = p_serial_number;
74: BEGIN
75:
76: OPEN c_customer_id;

Line 171: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a

167: -- Function : Get_CP_From_SerialNum
168: -- Usage : Used by the Routing module to get the customer product ID
169: -- From the serial number
170: -- Description : This function retrieves a customer product ID from the
171: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a
172: -- product. If there are more than one customer product
173: -- associated with the given serial number, this function will
174: -- return the first customer product ID that it retrieves.
175: -- Parameters :

Line 187: p_customer_product_id cs_customer_products_all.customer_product_id%type;

183: FUNCTION Get_CP_From_SerialNum
184: ( p_serial_number IN VARCHAR2)
185: RETURN NUMBER IS
186:
187: p_customer_product_id cs_customer_products_all.customer_product_id%type;
188:
189: --
190: -- get customer product ID given a serial number
191: --

Line 194: FROM cs_customer_products_all

190: -- get customer product ID given a serial number
191: --
192: CURSOR c_customer_product_id IS
193: SELECT customer_product_id
194: FROM cs_customer_products_all
195: WHERE current_serial_number = p_serial_number;
196: BEGIN
197:
198: OPEN c_customer_product_id;

Line 252: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a

248: -- Function : Get_Product_From_SerialNum
249: -- Usage : Used by the Routing module to get the inventory item ID
250: -- from the serial number
251: -- Description : This function retrieves an inventory item ID from the
252: -- CS_CUSTOMER_PRODUCTS_ALL table given a serial number of a
253: -- product.
254: -- Parameters :
255: -- p_serial_number IN VARCHAR2(30) Required
256: --

Line 265: p_inventory_item_id cs_customer_products_all.inventory_item_id%type;

261:
262: FUNCTION Get_Product_From_SerialNum
263: ( p_serial_number IN VARCHAR2)
264: RETURN NUMBER IS
265: p_inventory_item_id cs_customer_products_all.inventory_item_id%type;
266:
267: --
268: -- get inventory item ID given a serial number
269: --

Line 272: FROM cs_customer_products_all

268: -- get inventory item ID given a serial number
269: --
270: CURSOR c_inventory_item_id IS
271: SELECT inventory_item_id
272: FROM cs_customer_products_all
273: WHERE current_serial_number = p_serial_number;
274: BEGIN
275:
276: OPEN c_inventory_item_id;