APPS.CZ_CF_API dependencies on MTL_SYSTEM_ITEMS_KFV

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

840: END check_if_new_revision;
841:
842: -----------------------------------------------
843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)

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

843: ------Procedure that retrieves description and item name
844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:
851: BEGIN

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

844: ------from mtl_system_items_kfv for an inventory_item_id and organization_id
845: PROCEDURE get_item_description_and_name (p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
846: p_organization_id IN mtl_system_items.organization_id%TYPE,
847: x_description OUT NOCOPY mtl_system_items_kfv.description%TYPE,
848: x_item_name OUT NOCOPY mtl_system_items_kfv.concatenated_segments%TYPE)
849: IS
850:
851: BEGIN
852: ----get description,itemname from mtl_system_items

Line 855: FROM mtl_system_items_kfv

851: BEGIN
852: ----get description,itemname from mtl_system_items
853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:

Line 856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id

852: ----get description,itemname from mtl_system_items
853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:
860: --------------------------------------------------

Line 857: AND mtl_system_items_kfv.organization_id = p_organization_id;

853: SELECT description,concatenated_segments
854: INTO x_description,x_item_name
855: FROM mtl_system_items_kfv
856: WHERE mtl_system_items_kfv.inventory_item_id = p_inventory_item_id
857: AND mtl_system_items_kfv.organization_id = p_organization_id;
858: END;
859:
860: --------------------------------------------------
861: ------procedure that logs a delta message to

Line 874: l_description mtl_system_items_kfv.description%TYPE;

870: p_message_name IN fnd_new_messages.message_name%TYPE)
871:
872: IS
873:
874: l_description mtl_system_items_kfv.description%TYPE;
875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
876: v_OracleSequenceIncr NUMBER := 20;
877: l_msg_seq NUMBER := 0;
878: l_delta_message VARCHAR2(2000);

Line 875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

871:
872: IS
873:
874: l_description mtl_system_items_kfv.description%TYPE;
875: l_new_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
876: v_OracleSequenceIncr NUMBER := 20;
877: l_msg_seq NUMBER := 0;
878: l_delta_message VARCHAR2(2000);
879: