APPS.CSC_ROUTING_UTL dependencies on CS_CUSTOMER_PRODUCTS_ALL

Line 658: -- Description : This function finds a row in the CS_CUSTOMER_PRODUCTS_ALL

654: ------------------------------------------------------------------------------
655: -- Function : Is_CP_Existent
656: -- Usage : Used by the Routing module to determine whether a customer
657: -- product exists in the installed base with the given ID
658: -- Description : This function finds a row in the CS_CUSTOMER_PRODUCTS_ALL
659: -- table that matches the given customer product ID.
660: -- Parameters :
661: -- p_customer_product_id IN NUMBER Required
662: --

Line 678: FROM cs_customer_products_all

674: -- check if the given customer product ID exists
675: --
676: CURSOR c_customer_product_id (prodid NUMBER) IS
677: SELECT customer_product_id
678: FROM cs_customer_products_all
679: WHERE customer_product_id = prodid;
680: BEGIN
681:
682: OPEN c_customer_product_id(p_customer_product_id);

Line 751: p_customer_product_id cs_customer_products_all.customer_product_id%type;

747: FUNCTION Get_CP_From_ReferenceNum(p_reference_number IN NUMBER)
748: RETURN NUMBER IS
749:
750:
751: p_customer_product_id cs_customer_products_all.customer_product_id%type;
752:
753: --
754: -- get customer product ID given a reference number
755: --

Line 758: FROM cs_customer_products_all

754: -- get customer product ID given a reference number
755: --
756: CURSOR c_customer_product_id (refnum NUMBER) IS
757: SELECT customer_product_id
758: FROM cs_customer_products_all
759: WHERE reference_number = refnum;
760:
761: BEGIN
762:

Line 790: p_inventory_item_id cs_customer_products_all.inventory_item_id%type;

786: ------------------------------------------------------------------------------
787:
788: FUNCTION Get_Product_From_ReferenceNum(p_reference_number IN NUMBER)
789: RETURN NUMBER IS
790: p_inventory_item_id cs_customer_products_all.inventory_item_id%type;
791:
792: --
793: -- get inventory item ID given a reference number
794: --

Line 797: FROM cs_customer_products_all

793: -- get inventory item ID given a reference number
794: --
795: CURSOR c_inventory_item_id (refnum NUMBER) IS
796: SELECT inventory_item_id
797: FROM cs_customer_products_all
798: WHERE reference_number = refnum;
799: BEGIN
800:
801: OPEN c_inventory_item_id(p_reference_number);