APPS.CZ_CF_API dependencies on MTL_SYSTEM_ITEMS_KFV

Line 814: ------from mtl_system_items_kfv for an inventory_item_id and organization_id

810: END check_if_new_revision;
811:
812: -----------------------------------------------
813: ------Procedure that retrieves description and item name
814: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
815: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
816: p_organization_id IN mtl_system_items.organization_id%TYPE,
817: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
818: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)

Line 817: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,

813: ------Procedure that retrieves description and item name
814: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
815: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
816: p_organization_id IN mtl_system_items.organization_id%TYPE,
817: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
818: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
819: IS
820:
821: BEGIN

Line 818: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)

814: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
815: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
816: p_organization_id IN mtl_system_items.organization_id%TYPE,
817: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
818: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
819: IS
820:
821: BEGIN
822: ----get description,itemname from mtl_system_items

Line 825: FROM mtl_system_items_kfv

821: BEGIN
822: ----get description,itemname from mtl_system_items
823: SELECT description,concatenated_segments
824: INTO x_description,x_item_name
825: FROM mtl_system_items_kfv
826: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
827: AND mtl_system_items_kfv.organization_id = p_organization_id;
828: END;
829:

Line 826: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id

822: ----get description,itemname from mtl_system_items
823: SELECT description,concatenated_segments
824: INTO x_description,x_item_name
825: FROM mtl_system_items_kfv
826: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
827: AND mtl_system_items_kfv.organization_id = p_organization_id;
828: END;
829:
830: --------------------------------------------------

Line 827: AND mtl_system_items_kfv.organization_id = p_organization_id;

823: SELECT description,concatenated_segments
824: INTO x_description,x_item_name
825: FROM mtl_system_items_kfv
826: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
827: AND mtl_system_items_kfv.organization_id = p_organization_id;
828: END;
829:
830: --------------------------------------------------
831: ------procedure that logs a delta message to

Line 844: l_description mtl_system_items_kfv.description%TYPE;

840: p_message_name IN fnd_new_messages.message_name%TYPE)
841:
842: IS
843:
844: l_description mtl_system_items_kfv.description%TYPE;
845: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
846: v_OracleSequenceIncr NUMBER := 20;
847: l_msg_seq NUMBER := 0;
848: l_delta_message VARCHAR2(2000);

Line 845: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

841:
842: IS
843:
844: l_description mtl_system_items_kfv.description%TYPE;
845: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
846: v_OracleSequenceIncr NUMBER := 20;
847: l_msg_seq NUMBER := 0;
848: l_delta_message VARCHAR2(2000);
849: