548: L_api_version CONSTANT NUMBER := 1.0;
549: L_api_name CONSTANT VARCHAR2(30) := 'SendNotifications';
550: L_user_name VARCHAR2(100);
551: L_notification_id NUMBER;
552: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;
553: L_organization_code VARCHAR2(3);
554: L_msg_name VARCHAR2(30);
555: l_org_id NUMBER; -- MOAC parameter
556: l_ou_org_id NUMBER; --Bug#6509349
557:
558: --
559: CURSOR L_Item_crs IS
560: SELECT concatenated_segments
561: FROM mtl_system_items_kfv
562: WHERE inventory_item_id = p_inventory_item_id
563: AND organization_id = p_organization_id;
564: --
565: CURSOR L_Org_crs IS
990: p_inventory_item_id IN NUMBER,
991: p_organization_id IN NUMBER
992: )
993: IS
994: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;
995: BEGIN
996: BEGIN
997: SELECT concatenated_segments
998: INTO L_item_conc_segments
995: BEGIN
996: BEGIN
997: SELECT concatenated_segments
998: INTO L_item_conc_segments
999: FROM mtl_system_items_kfv
1000: WHERE organization_id = p_organization_id
1001: AND inventory_item_id = p_inventory_item_id;
1002: EXCEPTION
1003: WHEN OTHERS THEN